how to do different process using gridview with diff pages?

Question

I want to do add,update,insert,delete 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(Empname,EmpFname,EmpLname,Empcity,Empstate) 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/

how to do different process using gridview with diff pages?

Answers (4)