foreach (DataRow drow in ds.Tables[0].Rows) { string uri2 = "http://myrestURL/Transaction/" + drow.ItemArray[0].ToString(); HttpWebRequest req2 = HttpWebRequest.CreateHttp(uri2); req2.CookieContainer = new CookieContainer(); req2.Method = "GET"; req2.UseDefaultCredentials = true; req2.ContentLength = 0; req2.Accept = "application/xml,*/*"; req2.AutomaticDecompression = DecompressionMethods.GZip | DecompressionMethods.Deflate; using (HttpWebResponse resp2 = (HttpWebResponse)req2.GetResponse()) { StringReader theReader; DataSet theDataSet; using (StreamReader reader2 = new StreamReader(resp2.GetResponseStream())) { string message2 = reader2.ReadToEnd(); theReader = new StringReader(message2.ToString()); theDataSet = new DataSet(); theDataSet.ReadXml(theReader); DataTable dt = theDataSet.Tables["table1"]; DataTable dt1 = theDataSet.Tables["table2"]; DataTable dt2 = theDataSet.Tables["table3"]; DataTable dt3 = theDataSet.Tables["table4"]; dt.Columns.Add("ID", typeof(string)); dt.Columns["ID"].SetOrdinal(0); foreach (DataRow row in dt.Rows) { row["ID"] = drow.ItemArray[0].ToString(); } dt1.Columns.Add("ID", typeof(string)); dt1.Columns["ID"].SetOrdinal(0); foreach (DataRow row in dt1.Rows) { row["ID"] = drow.ItemArray[0].ToString(); } dt2.Columns.Add("ID", typeof(string)); dt2.Columns["ID"].SetOrdinal(0); foreach (DataRow row in dt2.Rows) { row["ID"] = drow.ItemArray[0].ToString(); } dt3.Columns.Add("ID", typeof(string)); dt3.Columns["ID"].SetOrdinal(0); foreach (DataRow row in dt3.Rows) { row["ID"] = drow.ItemArray[0].ToString(); } SqlConnection insertConn = new SqlConnection(strConn); insertConn.Open(); using (SqlBulkCopy bulkCopy1 = new SqlBulkCopy(insertConn)) { bulkCopy1.DestinationTableName = dt1.TableName; try { bulkCopy1.WriteToServer(dt1); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)