Store a DataTable from ASP.NET into Sql Server
I've a GridView in which i'm inserting lots of records it may be 100 or 500. And holding those values in a DataTable and there is a Save button after clicking on that button those records of DataTable being saved in Sql Server 2005. Currently i'm taking that DataTable values in a variable and serperating them with Comma(,). And at sql side i'm serperating them with comma and saving the records in Table in Sql Server. And that's working fine. But is it any other way to save or send the whole datatable in a single turn not concating in a string variable and save them at sql server.
Last edited by Manoj Bisht; February 22nd, 2010 at 08:22 AM..