how to do different process using gridview with diff pages?

Question

I want to do addupdateinsertdelete process using grid view and I want to take different pages for all these process... How can i do ?? please tell me some ideas to do such a thing..

Satyapriya Nayak · Answer

Default.aspx Untitled Page HeaderStyle-BackColor=#7779AF HeaderStyle-ForeColor=White DataKeyNames=Empid ForeColor=#663300 Font-Bold=True> '> Default.aspx.cs using System; using System.Collections; using System.Configuration; using System.Data; 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; using System.Data.SqlClient; namespace Gridview_update_other_page { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { BindGrid(); } } protected void BindGrid() { SqlConnection con = new SqlConnection(connStr); con.Open(); str = select * from employee; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); //com.ExecuteNonQuery(); con.Close(); ds = new DataSet(); sqlda.Fill(ds employee); GridView1.DataSource = ds; GridView1.DataMember = employee; GridView1.DataBind(); } } } Insert.aspx Untitled Page Insert Employee Details Width=100px> Width=100px> Width=100px> Width=100px> Width=100px> Font-Bold=True onclick=btn_insert_Click /> Insert.aspx.cs using System; using System.Collections; using System.Configuration; using System.Data; 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; using System.Data.SqlClient; namespace Gridview_update_other_page { public partial class Insert : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; string str; protected void btn_insert_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(connStr); con.Open(); str = insert into employee(EmpnameEmpFnameEmpLnameEmpcityEmpstate) values(' + txtFullName.Text + '' + txtFName.Text + '' + txtLName.Text + '' + txtcity.Text + '' + txtstate.Text + '); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); Response.Redirect(Default.aspx); } protected void Page_Load(object sender EventArgs e) { } } } Update.aspx Untitled Page function Display(Empname) { alert(Empname + ':::updated successfully'); if (alert) { window.location = 'Default.aspx'; } } Edit Employee Details EmpName: FName: LName: City: State: Update.aspx.cs using System; using System.Collections; using System.Configuration; using System.Data; 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; using System.Data.SqlClient; namespace Gridview_update_other_page { public partial class Update : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; string str; int empid = 0; protected void Page_Load(object sender EventArgs e) { empid = Convert.ToInt32(Request.QueryString[Empid].ToString()); if (!IsPostBack) { Bind(); } } private void Bind() { SqlConnection con = new SqlConnection(connStr); con.Open(); str = select * from employee where Empid= + empid; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); com.ExecuteNonQuery(); con.Close(); ds = new DataSet(); sqlda.Fill(ds); lblFullName.Text = ds.Tables[0].Rows[0][1].ToString(); txtFName.Text = ds.Tables[0].Rows[0][2].ToString(); txtLName.Text = ds.Tables[0].Rows[0][3].ToString(); txtcity.Text = ds.Tables[0].Rows[0][4].ToString(); txtstate.Text = ds.Tables[0].Rows[0][5].ToString(); } protected void btnUpdate_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(connStr); con.Open(); str = update employee set EmpFname=' + txtFName.Text + 'EmpLname=' + txtLName.Text + 'Empcity=' + txtcity.Text + 'Empstate=' + txtstate.Text + ' where Empid= + empid; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); int result = com.ExecuteNonQuery(); con.Close(); if (result == 1) { ScriptManager.RegisterStartupScript(this this.GetType() ShowSuccess javascript:Display(' + lblFullName.Text + ') true); } } protected void btnCancel_Click(object sender EventArgs e) { Response.Redirect(~/Default.aspx); } } }

darsh antani · Answer

thanks... for the code... this helped me.

darsh antani · Answer

thnx.. can this be converted into C#.NET? how?

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/update-records-of-a-table-through-differente-page-in-Asp-Net/