i am making a website and i am going to integrate webservices into it,.i need to pass the below specified url ,load the xml data from the url and save into database.
DataSet ds;
SqlDataAdapter da;
SqlConnection con;
ds = new DataSet();
con = new SqlConnection(@"Data Source=;Initial Catalog=;Integrated Security=True");
ds.ReadXml("http://letitgo.asia/api/serviceTrans.go?apimode=test&goid=5011000001&password=test123&rtype=xml&service_family=01&msisdn=98989898&operator_code=28&amount=20&client_transid=1004");
SqlBulkCopy sbc = new SqlBulkCopy("Data Source=.;Initial Catalog=test;Integrated Security=True");
sbc.DestinationTableName = "vicky";
con.Open();
sbc.WriteToServer(ds.Tables[0]);
con.Close();
i am getting the xml data into my dataset....but the problem comes when i pass the dyanamic data into above url... ...
Go to the complete details ...