Functions

Home About US Contact US SiteMap E-Book

INSERTING RECORDS IN SQL SERVER

User Interface  <. aspx>
  -------------------

Code File:

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient ; 
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {

}
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("Trusted_Connection=true;DataBase=Praveen_DataBase");
        SqlCommand cmd = new SqlCommand("Insert into Table1 values(@Name,@Address,@Course,@Roll)",con );
        SqlParameter obj1 = new SqlParameter("@Name", DbType.StringFixedLength);
        obj1.Value = TextBox1.Text;
        cmd.Parameters.Add (obj1);
        SqlParameter obj2 = new SqlParameter("@Address", DbType.StringFixedLength);
        obj2.Value = TextBox2.Text;
        cmd.Parameters.Add (obj2);
        SqlParameter obj3 = new SqlParameter("@Course", DbType.StringFixedLength);
        obj3.Value = TextBox3.Text;
        cmd.Parameters.Add (obj3);
        SqlParameter obj4 = new SqlParameter("@Roll", DbType.Int32.ToString());
        obj4.Value = TextBox4.Text;
        cmd.Parameters.Add (obj4);
        con.Open();
        cmd.ExecuteNonQuery();
        Label1.Text = "Record is Inserted";
        con.Close();

}

1	INSERTING RECORDS IN SQL SERVER
2	DISPLAY RECORD OF DATABASE IN GRIDVIEW
3	UPDATE RECORD OF DATABASE
4	DELETE RECORD OF DATABASE
5	DROP DWON LIST BINDING FROM DATA BASE
6	RADIO BUTTON LIST BINDING FORM DATABASE
7	CHECK BOX LIST BINDING FROM DATA BASE
8	LIST BOX BINDING FORM DATA BASE
9	DROP DWON LIST
10	RADIO BUTTON LIST
11	CHECKBOX LIST
12	LIST BOX
13	EDITING DATA IN GRID
14	CRYSTAL REPORT
15	DISPLAYING DATA OF XML FILE
16	INSERTING RECORD IN XML FILE
17	LOGIN PAGE


www.balujalabs.com	www.tutorjugaad.com	www.delhisikhmatrimonial.com	www.ignoujugaad.com
Privacy policy
Copy right © balujalabs.com All Right