Bulk Insert into database from datatable or dataset or datagrid

[yesu prakash]

Hi, How to insert a bulk data from a datatable or dataset or datagrid into database in a single click. Thankyou YPKI

[rkrishnach]

Add all rows to the datatable. Then use sqlbulkcopy.It inserts all the records into database table in one shot. SqlConnection destinationConnection = new SqlConnection(strConnection); destinationConnection.Open(); SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection ); bulkCopy.DestinationTableName = "destination"; bulkCopy.WriteToServer(yourDatatable); destinationConnection .Close();