Introduction
Represents a parameter to a SqlCommand and optionally its mapping to DataSet. Simply you can say, you can add parameter to SqlParameter constructor. Likenew 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" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
Name :
<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>
</div>
</form>
</body>
</html>
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;
con.Open();
int a=cmd.ExecuteNonQuery();
if (a>0)
{
Label1.Text = "sucess";
Label1.BackColor = System.Drawing.Color.Green;
Label1.ForeColor = System.Drawing.Color.White;
}
con.Dispose();
}
}
