Search

Thursday, October 10, 2013
0 comments

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

3:04 AMThursday, October 10, 2013

Introduction 

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" "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 :&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>
    </div>
    </form>
</body>

</html>
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;

        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();


    }
}


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

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

Protected by Copyscape Online Copyright Protection Software

0 comments :

Post a Comment

 
Toggle Footer
Top