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
<%@ PageLanguage="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 = newSqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
protected voidPage_Load(object sender, EventArgs e)
{
}
protected voidButton1_Click(object sender, EventArgs e)
{
SqlCommand cmd = newSqlCommand();
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();
}
}
Tidak ada komentar:
Posting Komentar