Edit and Update Record in GridView in ASP.Net

Good mey ajj

What is the accion that fires the edit mode in the grid? CommandName="Edit" ??

Hey.Is it possible if i just use 1 edit button for all the rows and when the update button is clicked the active row can be edited?

Hey, i want to be able to do the following: click edit botton-> new form open with row data in it's text field, then i do editing and update/save. please help me with such code

I am getting an error say "Object reference not set to an instance of an object." in line "DropDownList1.DataSource = dt;". Please reply with a solution.

There is no validation in that above example,,, i need validation before updating the username and other textboxes..

My values are not getting update after pressing update button. I retrieve data via response.write. It shows me old data. My code snippet is:- Label id = GridView1.Rows[e.RowIndex].FindControl("lbl_ID") as Label; TextBox name = GridView1.Rows[e.RowIndex].FindControl("txt_name") as TextBox; TextBox city = GridView1.Rows[e.RowIndex].FindControl("txt_City") as TextBox; Response.Write(name.Text); Response.Write(city.Text); Pls. tell mewhat to do to get new updated values.

Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation. I have set EnableEventValidation="false" for the page but textbox in the gridview is not converting as textbox hence could able to modify. Please help me out in this regards.

Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation. im running in vs2010 and ms access i am facing this probelm kindly help me out

Hey Anoop, nice post, very useful! When in Edit mode, can I change the field to a DropDownList ? I need to limit input options for users.

Or else.. I have planned for two gridviews.. How to update both with a single button?

Hi... Is it possible to have one row of gridview in two lines??

Anoop sir.. kindly tell me about " DataTable dt; "...

Its very useful

I need to give the name buttons column in the gridview

Can i give a name (events) to edit,update button column in gridview

Thank you very much bro..

Hey, I have done as you said but my data won't change when I update. It maintains the same value.

How To Use with RadioButton(MALE /FEMALE)

Give me source code

Hello i want to change button text after click on button ex. when i click on edit button and it replace name edit as a update not use grid view normal button and then i update user profile

Good Demo project...

Good one.... can you help how to calculation in row between Rate * Qty =Total

It will just update in the webpage only it doesn't affect database values could you please provide solution to update database also..

Protected void GrdV1_RowEditing(object sender, GridViewEditEventArgs e) { GrdV1.EditIndex = e.NewEditIndex; Display(); } protected void GrdV1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GrdV1.EditIndex = -1; Display(); } protected void GrdV1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string Sno = GrdV1.DataKeys[e.RowIndex].Value.ToString(); string str2 = "Delete from Userinfo where CardId='" + Sno + "'"; DataTable dg = cl.databyQ(str2); Display(); Response.Write("<script>alert('Record Delete Successfully')</script>"); } protected void GrdV1_RowUpdating(object sender, GridViewUpdateEventArgs e) { Label id = GrdV1.Rows[e.RowIndex].FindControl("lbl_ID") as Label; TextBox name = GrdV1.Rows[e.RowIndex].FindControl("txt_Name") as TextBox; string sql = "update Userinfo set UName='" + name + "' where CardId='"+id+"'"; DataTable ds = cl.databyQ(sql); GrdV1.EditIndex = -1; Display(); }

Update opration are not work sir help me

Nice one bro ...

Superb article thank you ! The 'Final Preview' is a great idea so we can see what we're aiming for :-)

String str = System.Configuration.ConfigurationManager.ConnectionStrings["WebConnectionString"].ToString(); cn = new MySqlConnection(str); cn.Open(); TextBox id = GridView1.Rows[e.RowIndex].FindControl("TextBox1") as TextBox; TextBox problem = GridView1.Rows[e.RowIndex].FindControl("TextBox3") as TextBox; TextBox closeTime = GridView1.Rows[e.RowIndex].FindControl("TextBox5") as TextBox; TextBox st = GridView1.Rows[e.RowIndex].FindControl("TextBox6") as TextBox; string cl = "UPDATE cms.complain_master SET ProbDetails='"+problem.Text+"',EndDate='"+closeTime.Text+"',Status='Close' where CPID='"+id.Text+"'"; cmdCloser = new MySqlCommand(cl,cn); cmdCloser.ExecuteNonQuery(); cn.Close();

I can update values on webpage only and after selection of update button it will store old values only in database. It can't find new values which i have changed. Please help me...

protected void GridView1_RowUpdating(object sender, System.Web.UI.WebControls.GridViewUpdateEventArgs e) { //Finding the controls from Gridview for the row which is going to update Label Name = GridView1.Rows[e.RowIndex].FindControl("e_name") as Label; Label EmpID = GridView1.Rows[e.RowIndex].FindControl("e_id") as Label; Label RqID = GridView1.Rows[e.RowIndex].FindControl("r_id") as Label; TextBox reqstip = GridView1.Rows[e.RowIndex].FindControl("r_ip") as TextBox; con.Open(); //updating the record MySqlCommand cmd = new MySqlCommand("Update req SET r_ip = '" + reqstip.Text + "' WHERE r_id=" +RqID.Text, con); cmd.ExecuteNonQuery();

this is the full code of the update event.. please help me in this

I'm trying this code on my project but it is saying that Object reference not set to an instance of an object. can u please help me in this??

MySqlCommand cmd = new MySqlCommand("Update req SET r_ip = '" + reqstip.Text + "' WHERE r_id=" +RqID.Text, con);

Thank you so much for such a simple explanation. But if I want to delete and add new data in database then what changes should I do in my code??. Please answer my question as soon as possible. I really want to know . It will be very beneficial for my project.