Loading

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

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

Arjun kumar

8y752Visual Basic .NET

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sankara Krishnan Venugopal8y ago
Accepted 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.
0
Sankara Krishnan Venugopal8y ago
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.
0
Arjun kumar8y ago
Thanks. but it will impact on performance. any other way.
0
Sankara Krishnan Venugopal8y ago
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.
+1