How to save data from DataTable to Database without looping using C# in ASP.Net

Question

SavingBulk Save more data from datatable in aspnet  c to table in databasewuthout using for or foreach loop

AnandM · Accepted Answer

Hi  TharaniYou can use below sample code but you need to mention all the column names for inserting into table because without column mapping data cannot be insertedCif dtRowsCount gt 0            string consString  ConfigurationManagerConnectionStrings34constr34ConnectionString        using SqlConnection con  new SqlConnectionconsString                    using SqlBulkCopy sqlBulkCopy  new SqlBulkCopycon                            Set the database table name                sqlBulkCopyDestinationTableName  34dboCustomers34                 OPTIONAL Map the DataTable columns with that of the database table                sqlBulkCopyColumnMappingsAdd34Id34 34CustomerId34                sqlBulkCopyColumnMappingsAdd34Name34 34Name34                sqlBulkCopyColumnMappingsAdd34Country34 34Country34                conOpen                sqlBulkCopyWriteToServerdt                co

How to save data from DataTable to Database without looping using C# in ASP.Net

Company

Explore

Follow us

Contact Us