I am making a website in which i need to load xml file from url.i am getting the into dataset but it is not able to save into database.i am getting the following error....
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)
below is my private method which i had been calling from page load
private void filloperatorcode()
{
DataSet ds = new DataSet();
SqlDataAdapter da;
SqlConnection con;
con = new SqlConnection(@"Data Source=;Initial Catalog=;Integrated Security=True");
ds.ReadXml("http://letitgo.asia/api/serviceData.go?apimode=test&goid=5011000001&password=test123&rtype=xml");
SqlBulkCopy sbc = new SqlBulkCopy("Data Source=.;Initial Catalog=test;Integrated Security=True");
sbc.DestinationTableName = "r_servicefamily";
con.Open();
sbc.WriteToServer(ds.Tables[0]); //This is the place where i am getting the error
DropDownList1.DataTextField = "service_family";
DropDownList1.DataValueField = "service_family";
DropDownList1.DataSource = ds;
DropDownList1.DataBind();
}