How to insert multiple records into database with SqlParameter in C#

October 10, 2013 , 0 Comments


Represents a parameter to a SqlCommand and optionally its mapping to DataSet. Simply you can say, you can add parameter to SqlParameter constructor. Like

new SqlParameter("variable name","value");

Pass this parameter to SqlCommand parameter.

SqlCommand cmd = new SqlCommand();  Like that 

Cmd . Parameter.Add(new SqlParameter("variable name","value")) ;

 Also you can represents some properties of the SqlParameter to SqlCommand something like that.

cmd.Parameters["variable name"].Value = value;
cmd.Parameters["variable name"].Size = 255;
cmd.Parameters["variable name"].SqlDbType = SqlDbType.NVarChar;

Lets take a Simple Example to Insert Multiple record using SqlParameter.

Source code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">

<html xmlns="">
<head runat="server">
    <form id="form1" runat="server">
    Name :&nbsp;&nbsp;
        <asp:TextBox ID="nmetxt" runat="server"></asp:TextBox> <br />

    Address:  <asp:TextBox ID="addtxt" runat="server"></asp:TextBox>
        <br />
        <br />
        <asp:Button ID="Button1" runat="server" Text="Submit" onclick="Button1_Click" />
        <br />
        <br />
        <asp:Label ID="Label1" runat="server"></asp:Label>

Codebehind File

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class _Default : System.Web.UI.Page
    SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
    protected void Page_Load(object sender, EventArgs e)

    protected void Button1_Click(object sender, EventArgs e)
        SqlCommand cmd = new SqlCommand();

        cmd .Parameters .Add(new SqlParameter("@name11",nmetxt .Text ));
        cmd.Parameters .Add (new  SqlParameter ("@Add",addtxt .Text ));
        cmd.Parameters["@name11"].Value = nmetxt.Text;
        cmd.Parameters["@name11"].Size = 255;
        cmd.Parameters["@name11"].SqlDbType = SqlDbType.NVarChar;

        cmd.Parameters["@Add"].Value = addtxt.Text;
        cmd.Parameters["@Add"].Size = 255;
        cmd.Parameters["@Add"].SqlDbType = SqlDbType.NVarChar;

        cmd.Connection = con;
        cmd.CommandText = "Insert into [dbtable](name1,Address)values(@name11,@Add)";
        cmd.CommandType = CommandType.Text;

        int a=cmd.ExecuteNonQuery();
        if (a>0)
            Label1.Text = "sucess";
            Label1.BackColor = System.Drawing.Color.Green;
            Label1.ForeColor = System.Drawing.Color.White;


How to insert multiple records into database with SqlParameter in C#

How to insert multiple records into database with SqlParameter in C#

Jacob Lefore

Some say he’s half man half fish, others say he’s more of a seventy/thirty split. Either way he’s a fishy bastard. Google