I am trying to read a string of xml into a dataset by using the following code
[Code]....
As I proceed to bind the 'dsParameters' to a gridview, I was thrown the 'The IListSource does not contain any data sources'. As I step through my code, I found that xmlSR is null. Any idea why is that so?
Having a hard time to get the .xls file data to a dataset:
Here is what I have done so far:
[Code]....
My .xml file example:
[Code]....
I want to read complete column from the dataset using select command or whatever without looping the rows of the table.Because in table i got 35000 records i only want to read a one complete column from the top to the end using dataset.
Eg: select column_name from table.
lly, dataset.tables[0].select["Column='Product'"]
I have tried with this but throwing exception.
I have a problem that I have been trying to solve the past two days, but I cannot figure it out...I have a folder which will have 60-70 Excel Files or CSV Files (they are right now). There are no headers in them, but they all have the same # of columns and the columns are in the same order in each fileI need to read each file in the folder, grab the data from the file and put it in a Database file. So all files will be read and then the data from them I guess put in a DataSet and then put into a Database (SQL).
View 3 RepliesI always thought we had to use a DataReader or a Dataset to read a given SQL data but i realized that it is not necessary to use them to read an SQL Output Parameter(im not a SQL expert).
View 1 RepliesI had a xml data, form that i need to get the values, as
<PREFERENCES>
<AccessNumber name="itfs">
<Features value="8067400680" Status="False" />
<Features value="8067400681" Status="False" />
</AccessNumber>
<AccessNumber name="sns">
[Code] ....
I need to get each attributes seperately, as
tollaccess
80677400567
false
Can I read from a dataset and create a hierarchical horizontal menu?
View 4 RepliesI unable to debug web service as it require dataset as parameter. Im having web application calling to web method of remote web service. I debug my web application up to call for web method but I want to debug web service as well by sending dataset as parameter. How to debug web service in such case?
View 6 Repliesi want to return a dataset, and consume it in the asp pages
how can i do that
suppose a dataset has 100 records, then how do i consume it in other websites
I have one problem is that when i send large dataset containing byte array.. then webservice not respond well..
it shows error like underlying connection was closed...
I mark that when dataset size goes some large then only problem occurs otherwise it works well..
how to send large dataset over web service..
In my project I have have a query in my Webservice
cmd=new SqlCommand("Select * From Record ;",conn);
conn.Open();
DataReader reader=cmd.ExecuteQuery();
now I want to return this Extracted data which may contain various rows and column
How can it be sent.???
One way is to Send it as XML Document But I don't know how to do this i.e. How to convert this set of record in to XML Document. and then How to retrieve values from this Document in a GridView at the requesting side.
I have recently converted all my applications to framework 4.0 and am very happy as a whole.
I have, however, run into a bit of a bind: i have exposed quite a few web services that have methods returning datasets.
Clients immediately started complaining that the order of the tables within the returned datasets were different. I investigated and can confirm that the webmethods are indeed shuffling the tables within the datasets. The order of tables in the method result are markedly different from the table order in the code before being returned.
My question is: is it possible to hard code the order of tables within the dataset being returned by a webmethod? I know that clients should, ideally, be referencing the tables via the table names, but that is - unfortunately - not the case in the really real world.
I have run into the issue on DataSet.WriteXml method. Apparently, if any row in a column in the DataSet has a null value, the entire column/rows will not write out in the xml file using the method DataSet.WriteXml. So, as terrible as that bug is, I need to send the data another way. Does anyone have any thoughts?
[Code]....
IN:
<soap:Envelope>
<soap:Body>
<testPing>
<apiKey>XDYYBE6Y336S3F</apiKey>
</testPing>
</soap:Body>
</soap:Envelope>
OUT:
<soap:Envelope>
<soap:Body>
<testPingResponse>
<pong>
<message>It works!</message>
</pong>
</testPingResponse>
</soap:Body>
</soap:Envelope>
I'd like to read data server-side from a web service that outputs in json format. I haven't found any good examples that don't use jquery and are server-side.
Specifically I'm looking at the "weight" field from this api:
[URL]
PS: this is a spin off of another post at: [URL]
I am developing a web application which uses a third party Web service. It requires Username & Password in SOAP Header request. I am passing those credentials well and the web service returns an XML string in Response and also a SESSION ID in the SOAP Header.
I don't know how to read/access the soap header from the response sent from the web service.
cant read http custome header "MSISDN" from my web service ... same code works on regular asp.net page. Can anyone shade a light on that subject ?
View 2 RepliesI have a web service running somewhere... I have added a reference of the same in my project. I had used SOAP UI to check the outgoing and incoming SOAP messages.
Now what i need is to MODIFY the SOAP message after it has been created (I wont be creating the soap message manually,) modify as in, I mean to insert some element into the header (such as public key etc) and encrypt the contents present in the body.
I have tried a lot of googling and have come to conclusion that i may have to use the SoapExtension Class.But i just dont understand how to do it.
There are method like ProcessMessage(... which require SoapMessage as input parameter. Now how to read
a generated SoapMessage is still unclear to me. I dont want to read the Soap message using tools (fiddler, soapui etc). I wish to read it programmatically.
I am having a scenario, where i need to decode ASP.NET FormsAuthentication Cookie in other language to accomplish Single Sign-On.
I am having a ASP.NET website, that also has WCF Authentication service. But I have just come know that even Java and PHP Application are also going to use my Authentication Gateway to authenticate user and so enable Single Sing-On.
I am done with the same in .NET application but to perform same in non-.NET techs, I need to decode FormsAuthentication Cookie of browser. FormsAuthentication Cookie are Encrypted so there must exist a algorithm that can decode it or a kind of dll that I can load in Java and read it.
I am downloading the project from the webservice which contains the zip file embedded in the Soap XML.
I want to read or download the content present in the Zip file.
I am using C#.
I create web service for Reading and writing the registry. It works fine in win-xp. But its not working when I published it in win-2008 server. It shows me http 500 error.
My Code is:
set Reg:
string key = @"SOFTWAREWow6432NodeMyCompanyMyProjectSettings";
string valuename = "Allow";
setRegistryValue(key, valuename, Value);
Get Reg:
string key = @"SOFTWAREWow6432NodeMyCompanyMyProjectSettings";
string valuename = "Allow";
return Convert.ToInt32(getRegistryValue(key, valuename));
i have a dataset and a table into named Students. Students(StudentName, age)
i wanna name colunm to string array. but not use loops (for foreach..). is there any way?
string[] array = this.dataSetZLC.Student.StudentNameColumn..
I am getting this JSON string from an ASP.Net webservice:
{"d":{"Table":[{"col1":123,"col2":"name","col3":"name","col4":100,"col5":"/Date(1153033200000)/"},{"col1":123,"col2":"name","col3":"name","col4":101,"col5":"/Date(1153033200000)/"},{"col1":123,"col2":"name","col3":"name","col4":102,"col5":"/Date(1153033200000)/"}]}}
In my jQuery how do I reference the Table code so I can loop through the data?
msg.d[i].col1
What am I missing? msg.d.table[i]?
i want to tranfer a xml string variable to DB2 store procedure. And then, i will open xml to get data to insert into tables . If in sqlserver i user OPENXML,.. But in DB2 i am a newmember. How can i do it in DB2 store procedure.
View 2 Replieshow can i get only
the year from string "dd/mm/yyyy" format
for example 31/12/2010
i want to display 2010 in a label1.text