My xml files looks like this:
Code:
<xml_response server="USVSTG01" version="1.21.03" code="0000" result_msg="SUCCESS">
jgn1013
Last Activity: May 1 '09, 02:26 PM
Joined: Jan 25 '07
Location:
-
xml to sql 2000 table
Pretty new to xml so if you could please point me in the right direction. I'm getting an httpwebresponse from a remote website in a xml format. I would like to either do a openxml stored procedure insert into a table or read through an xml file and insert data to a table. TIA
My xml files looks like this:
...Last edited by jgn1013; Jan 13 '09, 09:06 PM. -
parse xml file insert into database
This is what i'm currently doing, but what I would like is parse the xml only get phone, cellphone, name & userid.
I'm getting a http stream xml file: sample below
...Code:<root> <bhcontact name="john doe" userid="123"> <address>my address here</address> <phone>123-456-7890</phone> <cellphone>123-456-7888</cellphone>
-
I figured out my problem, it think. Before calling the web service, I have to set the ws.timeout = System.Threadin g.Timeout.Infin ite
so for anyone have timeout issue, after you instantiate your web service, you must set the timeout value.
thirdparty.webs ervice ws = new thirdparty.webs ervice
ws.timeout = System.Threadin g.Timeout.Infin ite -
asp.net timeout when calling a web service
I have a .net applicaiton that calls a third party web service. I beleive whe the query takes more then 1:43sec my connections closes giving me a timeout error. Do you think this has to do with my corporate firewall settings?
"
System.Net.WebE xception: The operation has timed-out.
at System.Web.Serv ices.Protocols. WebClientProtoc ol.GetWebRespon se(WebRequest request)
at System.Web.Serv ices.Protocols. HttpWebClientPr otocol.GetWebRe sponse(WebReque st... -
if you are talking abour declaring a variable in c# it will start with
string some_string_var iable
int some_int_variab le etc..Leave a comment:
No activity results to display
Leave a comment: