How can i post list data to sql tbl in XML format.

Question

How can we insert List(List ) data to sql table using ADO.net in XML format in c#.

Sankara Krishnan Venugopal · Answer

Arjun, The following steps will help you, - You can use the loop - Merge the records from excel sheet like DataTable or List - Make the format like col1,col2 and col3 (or) obj1, obj2 and obj3 - Load the records into database table Find the following url to read records from database. https://stackoverflow.com/questions/10704582/read-an-xslx-file-and-convert-to-list Thank you.

Sankara Krishnan Venugopal · Answer

Hi Arjun, You can use, public static bool InsertLink(List datas, string table) { bool results = false; List > values = new List >(); SqlConnection con = new SqlConnection("your connection string"); con.Open(); try { foreach (var Recordvalue in data) { values.Clear(); foreach (var item in Recordvalue.GetType().GetProperties()) { values.Add(new KeyValuePair (item.Name, item.GetValue(Recordvalue).ToString())); } string xQry = getInsertCommand(table, values); SqlCommand cmdi = new SqlCommand(xQry, con); cmdi.ExecuteNonQuery(); } results = true; } catch(Exception ex) { throw ex; } finally { con.Close(); } return result; } I hope this helps. Thanks.

Sankara Krishnan Venugopal · Answer

Yes. You can use the bulk insert option for performance optimization. https://www.codeproject.com/Articles/424742/How-to-bulk-insert-efficiently Hope this helps.

Arjun kumar · Answer

Thanks. but it will impact on performance. any other way.