Functions

Home About US Contact US SiteMap E-Book

UPDATE RECORD OF DATABASE

User Interface<.aspx>

CodeFile

using System;
using System.Collections;
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 UpdateRecord : 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("update Table1 set Name=@Name,Address=@Address,Course=@Course where Roll=@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 updated";
        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.delhisikhmatrimonia.com	www.ignoujugaad.com
Privacy policy
Copy right © balujalabs.com All Right