Save (Insert) multiple rows to database using SqlBulkCopy in ASP.Net

Hi akshaya,

I have created one sample that full-fill your requirement.

HTML

<div>
    <table>
        <tr>
            <td>
                First:
            </td>
            <td>
                <asp:TextBox ID="txtFirst" runat="server" />
            </td>
        </tr>
        <tr>
            <td>
                Second:
            </td>
            <td>
                <asp:TextBox ID="txtSecond" runat="server" />
            </td>
        </tr>
        <tr>
            <td>
                Third:
            </td>
            <td>
                <asp:TextBox ID="txtThird" runat="server" />
            </td>
        </tr>
        <tr>
            <td>
                Generated First Row:
            </td>
            <td>
                <asp:Label ID="lblFirstRow" runat="server" />
            </td>
        </tr>
        <tr>
            <td>
                Generated Second Row:
            </td>
            <td>
                <asp:Label ID="lblSecondRow" runat="server" />
            </td>
        </tr>
        <tr>
            <td align="center">
                <asp:Button ID="btnGenerate" Text="Generate Rows" runat="server" OnClick="GenerateRows" />
            </td>
            <td align="center">
                <asp:Button ID="btnInsert" Text="Insert" runat="server" OnClick="Save" />
            </td>
        </tr>
    </table>
    <asp:GridView runat="server" ID="gvResult" AutoGenerateColumns="false" EmptyDataText="No Record To Display !">
        <Columns>
            <asp:BoundField DataField="ID" HeaderText="Id" />
            <asp:BoundField DataField="Record" HeaderText="Record" />
        </Columns>
    </asp:GridView>
</div>

Code

string str = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        this.BindGrid();
    }
}
private void BindGrid()
{
    using (SqlConnection con = new SqlConnection(str))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT ID,Record FROM BulkInsert", con))
        {
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            gvResult.DataSource = dt;
            gvResult.DataBind();
            con.Close();
        }
    }
}
protected void GenerateRows(object sender, EventArgs e)
{
    lblFirstRow.Text = this.GenerateFirstRow();
    lblSecondRow.Text = this.GenerateSecondRow();
}
private string GenerateFirstRow()
{
    string first = txtFirst.Text.Trim();
    int second = int.Parse(txtSecond.Text.Trim());
    string result = "";
    for (int i = 1; i <= second; i++)
    {
        result = result + first + "B" + i + ",";
    }
    string firstRow = result.Remove(result.Length - 1, 1);
    return firstRow;
}
private string GenerateSecondRow()
{
    string first = txtFirst.Text.Trim();
    int third = int.Parse(txtThird.Text.Trim());
    string result = "";
    for (int i = 1; i <= third; i++)
    {
        result = result + first + "C" + i + ",";
    }
    string secondRow = result.Remove(result.Length - 1, 1);
    return secondRow;
}
protected void Save(object sender, EventArgs e)
{
    string firstRecord = lblFirstRow.Text;
    string secondRecord = lblSecondRow.Text;
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[1] { new DataColumn("Record", typeof(string)) });
    dt.Rows.Add(firstRecord);
    dt.Rows.Add(secondRecord);
    if (dt.Rows.Count > 0)
    {
        using (SqlConnection con = new SqlConnection(str))
        {
            using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
            {
                sqlBulkCopy.DestinationTableName = "dbo.BulkInsert";
                sqlBulkCopy.ColumnMappings.Add("Record", "Record");
                con.Open();
                sqlBulkCopy.WriteToServer(dt);
                con.Close();
            }
        }
    }
    this.BindGrid();
}

Screenshot