q; no insert

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have this code get xml string from web service and I am trying to insert
it into my table in the SQl server through, it does not give any error but it
does not insret the records too, what is problem?

myWS.myDS ds = new myWS.myDS();
myWS.Service ws = new myWS.Service();
System.IO.TextReader tr = new System.IO.StringReader(ws.LoadTable());
ds.ReadXml(tr, XmlReadMode.DiffGram);

daSR.TableMappings.Add("Table", "myTable");
daSR.Update(ds);
 
JIM.H. said:
Hello,

I have this code get xml string from web service and I am trying to insert
it into my table in the SQl server through, it does not give any error but it
does not insret the records too, what is problem?

myWS.myDS ds = new myWS.myDS();
myWS.Service ws = new myWS.Service();
System.IO.TextReader tr = new System.IO.StringReader(ws.LoadTable());
ds.ReadXml(tr, XmlReadMode.DiffGram);

daSR.TableMappings.Add("Table", "myTable");
daSR.Update(ds);
Click to expand...

We're going to need to see the code from the webservice and what the
..LoadTable() method does.
 
Thanks for your help. I do not have a control over web service but they
return dataset via WriteXml. Here is what I am getting when I dump tr to a
string: This is the XML returned by Web service:

<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1"><pTDS
xmlns="http://tempuri.org/pTDS.xsd"><myTable diffgr:id="myTable1"
msdata:rowOrder="0"
diffgr:hasChanges="inserted"><fNum>1064</fNum><fName>c4</fName><dD>ToDB</dD><dR>Nk</dR><ADT>2006-05-23T09:05:13.843-04:00</ADT><AUN>wssa</AUN></myTable><myTable
diffgr:id="myTable2" msdata:rowOrder="1"
diffgr:hasChanges="inserted"><fNum>1065</fNum><fName>t4</fName><dD>ToDB</dD><dR>Nk</dR><ADT>2006-05-23T09:05:28.687-04:00</ADT><AUN>wssa</AUN></myTable></pTDS></diffgr:diffgram>
 
Thanks for your help.
Here is how I create my adapter:
string sqlStr = "myStoredProcedure";
SqlCommand sqlCmd = new SqlCommand(sqlStr, sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter daSR = new SqlDataAdapter(sqlCmd);
SqlCommandBuilder cbSR = new SqlCommandBuilder(daSR);
 
JIM.H. said:
Thanks for your help.
Here is how I create my adapter:
string sqlStr = "myStoredProcedure";
SqlCommand sqlCmd = new SqlCommand(sqlStr, sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter daSR = new SqlDataAdapter(sqlCmd);
SqlCommandBuilder cbSR = new SqlCommandBuilder(daSR);
Click to expand...
Where do you open a connection?
 
Back
Top