using System.Data;
using System.Data.SqlClient;
try
{
if (SqlConnection.State == ConnectionState.Closed)
SqlConnection.Open();
using (SqlBulkCopy bcp = new SqlBulkCopy(SqlConnection))
{
bcp.DestinationTableName = "DataSourceTableName";
bcp.WriteToServer(DataTable, DataRowState.Added);
DataTable.AcceptChanges();
}
}
catch
{
DataTable.RejectChanges();
GridView.DataSource = DataTable.DefaultView;
GridView.DataBind();
}
finally
{
if (SqlConnection.State == ConnectionState.Open)
SqlConnection.Close();
}