Can we write a web service to watch a table in sql server. whenever the corresponding table is populated with new records, the new records should appended to the another table which has the same structure of the old one.Is this is possible using webservices if not how to perform this.
View 2 RepliesSSIS package is running successfully and the db table is not populating in sql server.I am using csv file to populate datas to database tables.
I am using flat file source and oledb destination in data flow in ssis.
I am creating a temp table and populating it's two columns manually and the rest of the table from the data returned by the stored procedure. When I added the first column called custno as @CustNumber, it allowed me to add it fine and the rest of the columns were filled by the stored procedure as expected. I then needed to add another column called RepeatCustomer the same way but it keeps saying:
Msg 207, Level 16, State 1 Invalid column name 'Repeatcustomer' So eventhough I have added Repeatcustomer column it's not seeing it. Any one has seen this error before or know what's wrong with this code. Note when I parse the query it's fine, it only fails upon the execution.
[Code]....
I am working on a website that uses SQL database. However, the database need to be populated every 24 hours by importing records from a text file. Can I use webservice to read text file and import records into database every night?
The Website will be in use 24 hours. Can Webservice still import records into database while website is being used?
I wanted to use using database to populated the dropdownbut i am getting error as type or list space cannot be foundat ListCountry GetCountriesas its defined staticthe web methood code is in the same aspx.cs pagehow culd i use it if a different webmethod page .asmx is created
ref : [URL]
i have a .net web site running on a IIS server in my office. i have various clients at home and i want to create/run a web site on my office server where i can view different client web cams. how to achieve that ?
i read some articles but they all had the web cam connected directly to the IIS server. in my case the web cam or cams are at remote client computers.
I'm writing an app (ASP.NET 2.0 w/ VB code behind) where my users complete a sign up process. Their data, such as name, address and phone info is stored in a SQL Server DB table. What I want is for them to be able to click a "Print Authorization" button that auto populates the authorization.pdf form and then let's the user print out the form to sign it.
How do I populate the Authorization.PDF with this info from the SQL table? Basically, I just need to know about putting the data on the PDF and then having it print. The file doesn't need to be saved, just populated with data and then printed. I have no experience with C# so the iText solution really won't work.
I am trying to populate table column names into a dropdown list . how can I query using Linq to SQL to just get the list of few Column names ? in a method in DAL which I can use to load in my UI page !!
View 2 RepliesI have an HTML page and I am binding elements to that HTML page from my aspx page. Now i want to bind multiple elements as a table format in my HTML page.
private void SendEmail(string OrderID, string CustomerEmail, string ProductName, string ProductPrice, string ProductFinalPrice, string Quantity, string Merchant, string ProductCode) {
string contents = File.ReadAllText(Server.MapPath("~/index.html"));
contents = contents.Replace("[Date]", DateTime.Now.ToString("dddd, dd MMMM yyyy"));
contents = contents.Replace("[OrdID]", OrderID);
[Code]......
I'm starting using web services in .net , I'd like to know how to achieve this:
I need to import table data into a database, currently what we do is uploading via ftp the text files, and then running a process in php in the webserver.
Could this be automated by sending those text files (or xml, or whatever format is necessary) to a webservice as an argument, and that the webservice handles the insert and validating process of the data?
I have a gridview that is populating from a SQL DB and working fine. However, based upon certain data I find in fields in the SQL table, I want to place a 'n' or a 'y' in extra columns in the gridview that I am assuming need to be templatefields. My thought was I could maybe add 8 template columns and then I could put a 'y' in the appropriate column based upon the data I find the table. For the life of me, I cannot figure out how to do this. I want to do this at rowdatabound time ( i think) but I just cannot find out how to, in my code, put that 'y' in the columns. Is this the right way to do this or do I need to do it another way? How do I get that 'y' in the proper column?
View 3 RepliesI need to write a webservice that returns multiple rows from a table. I am familiar with return of a single object.
I am calling a stored procedure in the webservice that populates a data table.
I guess I need to define an object collection to be returned. Should this be an array or can I return the data table itself?
I am "trying" to switch my form from SqlDataSources to ADO.NET data sources. So I have a DAL setup, and ObjectDataSources in my form referencing these DALs. These data sources are bound to the form's objects. So far so good. In the InsertItem Template of one of the form's FormViews I have a list box that I am trying to populate with a value pair (ID, TechName) from a database table and I get the following error:
"Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control." Apparently, one of the two workarounds involves programmatically loading the listbox. The code below shows one of my attempts, resulting in the above mentioned error:
Code:
Protected Sub TestFillDefaultValueInFormView()
Dim vInspectorList As DropDownList
If (FormViewHydInspection.CurrentMode = FormViewMode.Insert) And Not IsPostBack Then
vInspectorList = DirectCast(FormViewHydInspection.FindControl("DDlstInspBy"), DropDownList)
vInspectorList.Items.Clear()
Dim vInspectorDA As New DataSetHydrantsTableAdapters.TechnicianTableAdapter()
Dim vInspectors As DataSetHydrants.TechnicianDataTable = vInspectorDA.GetTechnician()
Dim vInspRow As DataSetHydrants.TechnicianRow
Dim vInspectorHT As New Hashtable
vInspectorHT.Add("0", "Select Technician")
For Each vInspRow In vInspectors
If vInspRow.TechID <> 0 Then
vInspectorHT.Add(vInspRow.TechID.ToString, vInspRow.TechName)
End If
Next
vInspectorList.DataSource = vInspectorHT
vInspectorList.DataTextField = "value"
vInspectorList.DataValueField = "key"
vInspectorList.DataBind()
End If
End Sub
I tried populating the listbox directly using the Listbox.Items.add() method (which is the way I have it now so I could continue solving other problems, and it works!) but I could not find a way to add a value pair. I did try:
vInspectorList.DataTextField = "Select Technician"
vInspectorList.DataValueField = "0"
but that left a listbox without any data.
Okay, I have developed VB.NET winforms applications and I understand that working with ASP.NET would be similar. However, this seems way complicated then I thought. Basically, i am working on accessing one table data from a database and populating data in a datagrid. I have few text boxes on the display page and if a user clicks on submit button i want a new set of data with new select statement based on user input.
I don't quite understand how the textbox value can be passed on the same page and a new select statement is generated, which then populates the datagrid.
I am trying to create a dynamic table that is being built based on the value of a search text box. The Table will have probably 6 columns of 20(max) rows.
My problem is I can't figure out how to return the data from the web-service to the JS function in a way that will allow me to extract the data that I need.
Here is the web-service method I have currently:
[code]....
I'm trying to retrive data from an SQL server db and populate one of the columns into a drop down list.
View 7 RepliesOne of my web pages populates a droplist with about 60k items pulled from SQL Server, and this operation takes upwards of 10 seconds to complete. Are there some tricks or optimizations I can try to improve performance? I'm using a SqlDataSource configured as a DataReader.
View 5 RepliesI need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 RepliesI have a .Net Webservice(2.0 framework) and I am trying to call this service from SQL
server 2005 using CLR.
I have created assamblies on server and trying to call the we service through CLR, but I'm getting below error:
"Exception:
Server was unable to process request. ---> Invalid URI: The URI is empty."
I have a textbox for City field and a drop down list box for office location which has to be filled up based on the City value.
How to populate the values of drop down list box from an xml file keeping the above consideration.
I am doing this in a asp.net user control and C# code behind
In future i need not change the code every time. Its only the xml file i change and the corresponding city related office locations get listed in the drop down list box.
I am referring to
[URL]
I have 2 tables:
- Salesmen with Pk.SalesmenID
- Appointments with Fk.SalesmenID and busy(bit)
How can I check if every salesmen has at least one appointment
Am I on the right way with statement below, though I got syntax problems
[Code]....
i am trying to create a temporary table as like an existing table.
create table #tmp AS ( select Table1.* from Table1 where Table1.column name in (select Table2.column name from Table2 where conditions) )
But it is showing Error...
how to add web service which is deployed in remote server. externally i unable to access that service..in that remote server only that service will run but we don't have Ms.net Environment to add service to my application in that server. how to add that web service to my application ,not accessig externally that service URl, internally Executing that URl. How can i add that service to my application on my developer PC ?
View 2 RepliesI want to create the webservice which works on wss document libray. I can upload document in document library using aspx webservice.
View 1 Replies