How to insert a data table into SQL Server database table?

You may try the SqlBulkCopy without looping:
SqlBulkCopy
SqlBulkCopy class

Hi Praveen,

If you are using SQL Server 2008 then its easy to do using Table object and Store procedure.
You can refer here[^] for samples.
Here[^] is how you can implement.

Hope this helps you a bit.

Regards,
RK

DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
                        new DataColumn("Name", typeof(string)),
                        new DataColumn("Country",typeof(string)) });
    foreach (GridViewRow row in GridView1.Rows)
    {
        if ((row.FindControl("CheckBox1") as CheckBox).Checked)
        {
            int id = int.Parse(row.Cells[1].Text);
            string name = row.Cells[2].Text;
            string country = row.Cells[3].Text;
            dt.Rows.Add(id, name, country);
        }
    }
    if (dt.Rows.Count > 0)
    {
        string consString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(consString))
        {
            using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
            {
                //Set the database table name
                sqlBulkCopy.DestinationTableName = "dbo.Customers";
 
                //[OPTIONAL]: Map the DataTable columns with that of the database table
                sqlBulkCopy.ColumnMappings.Add("Id", "CustomerId");
                sqlBulkCopy.ColumnMappings.Add("Name", "Name");
                sqlBulkCopy.ColumnMappings.Add("Country", "Country");
                con.Open();
                sqlBulkCopy.WriteToServer(dt);
                con.Close();
            }
        }
    }

Write in Stored Procedure Table name eg: MoodleUsersTable

use Sample
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<m.nabeel siddiqui="">
-- Create date: <19/4/2016>
-- Description:	<adding records="" in="" moodleusers="">
-- =============================================
Alter PROCEDURE InsertMoodleUsers
@MoodleUserTable MoodleUsersTable readonly

AS
BEGIN
insert into MoodleUsers select * from @MoodleUserTable
END
GO</adding></m.nabeel>

and c# code here

public void runsp(DataTable dt1,string spName)
        {
            SqlCommand cmd = new SqlCommand(spName, connection);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter dtparam = cmd.Parameters.AddWithValue("@MoodleUserTable", dt1);

            dtparam.SqlDbType = SqlDbType.Structured;
            Start();
            cmd.ExecuteNonQuery();
            Stop();
        }