Gridview Edit Delete And Update In ASP.NET

I have added a couple new colums to the Gridview such as: <Columns> <asp:BoundField DataField="regno" HeaderText="RegNo" /> <asp:BoundField DataField="name" HeaderText="Name" /> <asp:BoundField DataField="class" HeaderText="Class" /> <asp:BoundField DataField="mob" HeaderText="Contact" /> <asp:BoundField DataField="dob" HeaderText="DOB" /> <asp:BoundField DataField="gen" HeaderText="Gender" /> <asp:BoundField DataField="address" HeaderText="Address" /> <asp:CommandField ShowEditButton="true" /> <asp:CommandField ShowDeleteButton="true" /> </Columns> Here's the c# code: protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { int regno = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString()); GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex]; Label lblREGNO = (Label)row.FindControl("lblREGNO"); //TextBox txtname=(TextBox)gr.cell[].control[]; TextBox textName = (TextBox)row.Cells[0].Controls[0]; TextBox textc = (TextBox)row.Cells[1].Controls[0]; TextBox textmob = (TextBox)row.Cells[2].Controls[0]; TextBox textdob = (TextBox)row.Cells[3].Controls[0]; TextBox textgen = (TextBox)row.Cells[4].Controls[0]; TextBox textadd = (TextBox)row.Cells[5].Controls[0]; //TextBox textadd = (TextBox)row.FindControl("txtadd"); //TextBox textc = (TextBox)row.FindControl("txtc"); GridView1.EditIndex = -1; cn.Open(); //SqlCommand cmd = new SqlCommand("SELECT * FROM student", conn); SqlCommand cmd = new SqlCommand("update student set name='" + textName.Text + "',address='" + textadd.Text + "',class='" + textc.Text + "',gender='" + textgen.Text + "',contact='" + textmob.Text + "',dob='" + textdob.Text + "'where regno='" + regno + "'", cn); cmd.ExecuteNonQuery(); cn.Close(); gvbind(); //GridView1.DataBind(); } However, i'm getting an error that says: A field or property with the name 'mob' was not found on the selected data source. How do i add new columns to the gridview, as i have added 3 more columns but am not getting the output now?

Protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { } not hitting/working

I've found an error . this App Run with HiddenField1.Value = "view" but in Stored procedure don't exist @Action ="view" I've found only @Action='Select' .

Please Provide Code For Edit Column I have Not Required So How To Hide all Edit Column and I have required That Time I have Change Only One So One Of function Create For Editable Column

Delete function is not working..!! I don't know the reason.. There is no error message or anything but when it is clicked it just remains same..

Connection:<connectionStrings> <add name="strcon" connectionString="Server =DESKTOP-SQH5K1D; database=sudha; integrated security =True"/> </connectionStrings>

Namespace:using System.Configuration;using System.Data.SqlClient; using System.Data;

Class: static string con = ConfigurationManager.ConnectionStrings["strcon"].ConnectionString.ToString(); SqlConnection sqlcon = new SqlConnection(con); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { gridbind(); } } void gridbind() { sqlcon.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = sqlcon; cmd.CommandText = "select * from reg91"; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); GRID.DataSource = dt; GRID.DataBind(); sqlcon.Close(); } protected void link_Command(object sender, CommandEventArgs e) { int id = Convert.ToInt32(e.CommandArgument); sqlcon.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = sqlcon; cmd.CommandText = "select * from reg91 where id ="+ id+""; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if(dt.Rows.Count>0) { hndid.Value = dt.Rows[0]["id"].ToString(); txt1.Text = dt.Rows[0]["name"].ToString(); TextBox2.Text = dt.Rows[0]["emailid"].ToString(); bool active = Convert.ToBoolean(dt.Rows[0]["active"].ToString()); if(active==true) { actv.Checked = true; } else { actv.Checked = false; } btn.Text = "update"; } } protected void Delete_Command(object sender, CommandEventArgs e) { int id = Convert.ToInt32(e.CommandArgument); sqlcon.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = sqlcon; cmd.CommandText = "delete from reg91 where id =" + id + ""; cmd.ExecuteNonQuery(); sqlcon.Close(); gridbind(); } protected void btn_Click(object sender, EventArgs e) { sqlcon.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = sqlcon; int a = 0; if(actv.Checked==true) { a = 1; } else { a = 0; } string gender1 = ""; if(RadioButton1.Checked==true) { gender1 = "f"; } else if (RadioButton2.Checked == true) { gender1 = "m"; } if (btn.Text == "update") { cmd.CommandText = "update reg91 set name='" + txt1.Text + "',emailid='" + TextBox2.Text + "',country='" + TextBox3.Text + "',city='" + txtbox4.Text + "',gender='" + gender1 + "',active=" + a + " where id =" + Convert.ToInt32(hndid.Value) + ""; } else { cmd.CommandText = "insert into reg91(name,emailid,country,city,gender,active) values('" + txt1.Text + "','" + TextBox2.Text + "','" + TextBox3.SelectedItem.Text + "','" + txtbox4.SelectedItem.Text + "','" + gender1 + "'," + a + ")"; } cmd.ExecuteNonQuery(); sqlcon.Close(); btn.Text = "submit"; hndid.Value = null; txt1.Text = null; TextBox2.Text = null; TextBox3.Text = null; txtbox4.Text = null; actv.Text = null; actv.Checked = false; gridbind(); }

Webformdesign:<div> <table> <tr> <td>name</td> <td> <asp:TextBox ID="txt1" runat="server"></asp:TextBox> </td> </tr> <tr> <td>emailid</td> <td> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> </td> </tr> <tr> <td>country</td> <td> <asp:DropDownList ID="TextBox3" runat="server"> <asp:ListItem Value="2">us</asp:ListItem> <asp:ListItem Value="3">uk</asp:ListItem> </asp:DropDownList> </td> </tr> <tr> <td>city</td> <td> <asp:DropDownList ID="txtbox4" runat="server"> <asp:ListItem Value="1">kol</asp:ListItem> <asp:ListItem Value="2">del</asp:ListItem> <asp:ListItem Value="3">patna</asp:ListItem> </asp:DropDownList> </td> </tr> <tr> <td>gender</td> <td> <asp:RadioButton ID="RadioButton1" runat="server" Text="f" GroupName="1"></asp:RadioButton > <asp:RadioButton ID="RadioButton2" runat="server" Text="m" GroupName="1"></asp:RadioButton > </td> </tr> <tr> <td>active</td> <td> <asp:CheckBox ID="actv" runat="server" ></asp:CheckBox> </td> </tr> <tr> <td> <asp:Button ID="btn" runat="server" Text="submit" OnClick="btn_Click"></asp:Button> </td> </tr> </table> <table> <tr> <td> <asp:GridView ID="GRID" runat="server" AutoGenerateColumns="false"> <Columns> <asp:TemplateField HeaderText="Edit"> <ItemTemplate> <asp:linkbutton ID="link" runat="server" Text="update" OnCommand="link_Command" CommandArgument='<%#Eval("id") %>'></asp:linkbutton> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Delete"> <ItemTemplate> <asp:linkbutton ID="linkdelete" runat="server" Text="Delete" OnCommand="Delete_Command" CommandArgument='<%#Eval("id") %>'></asp:linkbutton> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="name"> <ItemTemplate> <asp:Label ID ="lblguserid" runat ="server" Text ='<%#Eval("name") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="emailid"> <ItemTemplate> <asp:Label ID ="lblguserid1" runat ="server" Text ='<%#Eval("emailid") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="country"> <ItemTemplate> <asp:Label ID ="lblguserid2" runat ="server" Text ='<%#Eval("country") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="city"> <ItemTemplate> <asp:Label ID ="lblguserid3" runat ="server" Text ='<%#Eval("city") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="active"> <ItemTemplate> <asp:Label ID ="lblguserid4" runat ="server" Text ='<%#Eval("active") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="gender"> <ItemTemplate> <asp:Label ID ="lblguserid5" runat ="server" Text ='<%#Eval("gender") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> </td> </tr> </table> </div> <asp:HiddenField ID="hndid" runat="server" />

I am getting error in webform

Label lbldeleteid = (Label)row.FindControl("lblID"); what is 'lbldeleteid' and 'lblID' con.Open(); I WANT TO DELETE RECORED FROM GRID VIEW USING OR AGAINST MY CLIENTNAME - HOW TO DO IT? SqlCommand cmd = new SqlCommand("DELETE FROM tbl_ClientDetails WHERE sClientNAme='" + Convert.ToInt32(grdView.DataKeys[e.RowIndex].ToString()) + "'", con);

Time waste

Public partial class billnew : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { displayrecord(); } } protected void Button1_Click(object sender, EventArgs e) { Connect c = new Connect(); c.getcon(); SqlCommand cmd = new SqlCommand("newbill1", c.con); cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = TextBox1.Text; cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); c.con.Close(); } protected DataTable displayrecord() //display { Connect c = new Connect(); c.getcon(); SqlDataAdapter adp = new SqlDataAdapter("select * from billnew", c.con); DataTable dt = new DataTable(); adp.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); return (dt); } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; displayrecord(); } protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridView1.EditIndex = -1; displayrecord(); } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { Connect c = new Connect(); c.getcon(); TextBox t1 = new TextBox(); t1 = (TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]; //TextBox t2 = new TextBox(); t2 = (TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]; string s = GridView1.DataKeys[e.RowIndex].Value.ToString();//to get id of row SqlCommand cmd = new SqlCommand("update billnew set name='" + t1.Text + "' ,age="+t2.Text+ " where id=" + s + "", c.con); cmd.ExecuteNonQuery(); c.con.Close(); GridView1.EditIndex = -1; displayrecord(); Response.Write("updated successfully"); } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { Connect c = new Connect(); c.getcon(); string s = GridView1.DataKeys[e.RowIndex].Value.ToString();//to get id of row SqlCommand cmd = new SqlCommand("delete from billnew where id=" + s + "", c.con); cmd.ExecuteNonQuery(); c.con.Close(); GridView1.EditIndex = -1; displayrecord(); Response.Write("updated successfully"); }

Update function is not working

Good explanation with examples, thanks to share

How To Use With Radiobutton

I need a gridview in which only the id's will be present and by clicking on an id we should get the details in the same gridview. Can anyone please help me with the code

What about if u provide another coloumn which contains images of that user and the number of images are may be more than one or two or three... So My question is In that case how u bind those multiple images with that particular user in gridview or any other div tag .

TextBox textName = (TextBox)row.Cells[0].Controls[0];Additional information: Unable to cast object of type 'System.Web.UI.WebControls.DataControlLinkButton' to type 'System.Web.UI.WebControls.TextBox'.

Neha this article is very very useful. Please u have any article for learning MVC then please paste URL/link in comment or mail me on [email protected] plz

Int userid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString()); I am facing this error "Index out of bound exception"

Your code with Errors...

Thank u very much! Glad to have your code and make our way for updating and deleting contents in data table EASY and FLEXIBLE

Please upload if u click save then registration from data go to gridview and and then edit the gridview The selected row go to text box upload this type exaple

I am thankful to you for sharing knowledge.

I am not able to update, due to control getting old value onRowUpdating Event.

Thanks for sharing ma'm....

Hi Neha, Would you please let us know the schema of detail table...?

Easy to learn and clear explained

Clear and well explained mam ...

Nice

Can i download your source code ? pls provide a download link

This is nice article ,

Nice...

Nice sharing..

Hi Neha...How you getting the FindControl("lblID"). when its a templatecolumn

nice

nice

Nice Explain.......

Good one

nice..

nice article

please

.I am having trouble in updating the records. When I click the update button nothing happens. I am pretty sure I have used the code correctly. Can u help me?

Thanks it's very helpfull

hi neha....I am having trouble in updating the records. When I click the update button nothing happens. I am pretty sure I have used the code correctly. Can u help me?

thanks.............from iran

GridView Edit Update Using BoundField http://patilranjeet.blogspot.in/p/aspnet-gridview-edit.html

very helpful article for me....help of this article I have done Edit and Delete, Thank u mam

http://www.getproductprice.com

http://www.interviewqsn.com

Hi below are some good sites too

hi i have converted this code to vb. im having errors could you help

is anybody help me for this how we can make this coding workable SQL Query create database test use test create table gridview(id int identity(1,1),ename varchar(50),city varchar(50)) insert into gridview values('nitin','hisar') insert into gridview values('deepak','gwalior') insert into gridview values('raman','delhi') select*from gridview update gridview set ename='nitin sharma', city='haryana' where id=1 default.aspx <asp:GridView ID="GridView1" runat="server" Height="189px" Width="332px" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" DataKeyNames="id" onrowcancelingedit="GridView1_RowCancelingEdit" onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating"> </asp:GridView> default.aspx.cs protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value); string name=GridView1.Rows[e.RowIndex].Cells[0].Text; string city=GridView1.Rows[e.RowIndex].Cells[1].Text; if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("update gridview set ename='" name "', city='" city "' where id='" id "'", con); cmd.ExecuteNonQuery(); con.Close(); GridView1.DataBind(); display(); } can you please check my code and tell me why this code not work correctly

Very simple and useful article........nice.....

i got erroe"DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'id'." what sould i do??

thank you...

Hi,Thanx it is very good post.I have one query How can we update image instead of text using above code?

Wen i try to edit the grid row i get error "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"

Very nice article its good work

ok ,try these links : http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html , http://www.codeproject.com/Articles/467788/Dynamically-adding-and-deleting-rows-from-ASP-NET ,

Neha I ahve a GridView with tha Fields Name Question ,POstBy,PostOn,Description ANd a Reply Link Lebal..When i click on Reply Button Then A New Row of Reply would b Created Which Has Reply,Reply By,Reply On

Neha Wt About mine Problem ? How to Create a GridView Like On Forum Pages.

Hii Neha...Thanks once again....i just want to ask that how can we add a dialogue box before deleting the record in this code???

Bt wt about mine Problem Mis. Neha ?

Yes...My problem is solved completely..Thanku soo much for your help & support....Your Code Rocks!!!!!

hi Shaily,let me know about your problem is that solved or not?

Hey neha check this link: http://www.c-sharpcorner.com/Blogs/11842/how-to-edit-delete-update-or-cancel-record-in-gridview-usi.aspx

As discussed send me the code aspx as well update

Hii Neha , the code is really helpful but it is showing error:Unable to cast object of type 'System.Web.UI.WebControls.DataControlLinkButton' to type 'System.Web.UI.WebControls.TextBox'. in update function. Please help me.

Thanks Neha, it works for me, can u describe that how to set the width of the TextBox in editable mode.. thanks in advance

Sure Abhimanyu..take your time.

hii Neha thax for this let me try it if i wil have any problebm i will ask you

Hi Abhimanyu,You can do this by export Gridview data in to pdf format and then can take printout as well can save each files.If you want to go through with this solution go here : http://www.c-sharpcorner.com/UploadFile/9f0ae2/export-gridview-into-pdf-in-Asp-Net/

Hii Neha, hope you are doing gr8 i need help once again form your side as you did earlier actually, I want the bulk data print(one by one all data from DB on dropdownlist Search/selection)from DataBase on dropdown select event....without gridview display only want print out in fixed format..

Hi Bhavneet,Please let me know "PROBLEM" or try to add brekapoint and filter your problem yourself.

Hi srikant,learn the validations in gridview http://forums.asp.net/t/1376279.aspx/1

Hi Neeraj,Youc an fetch values from gridviews based on datakey and when you have values you can show anywhere.

I Have a Problem while updating my gridview.

VERY GOOD ARTICLE:)now i need to give validation while editing in the text box.it should allow only char,int plz help on this

hi..., I have add crystal report..Work to use ok but how can I Value pass thru Parameter and SelectionFormulas in Crystal 9. so if u some little more help me..?

if you tried that let me know what kind of problem you are facing with that?

yeah exactally like that i tried also but did not get it now can you help me Plz thx

Abhimanyu i think now you want to show image pop-up to show large size of images?? if yes visit my blog recently i psted how to do that.thx

thx sreejesh for you kind words!!

Hii neha, I displayed images inside grid row but i reduced its size as thumbnails because there alignment is going too large.So is it possible to show actual size on clicking on their thumbnails. Sorry for my English i think you got it...

Dear Neha, Your code is correct,but this is not use in applcation level,this is used only Accademicsection Thanks Sreejsh

Sure

Thanks for gr8 Suggestion I am trying now after that i will ask you please.

Hi abhimanyu,while binding a gridview you can take a image control as the fields we have taken in asp:boundfields,and mention the filed name in datafield propery.hope you got it now.anywyas i would also suggest you to post your query in forum section,so that everyone can help you,else youc an ask it here also ,i would love to help if i can.

Hii, thax Neha i got it now Could you help me to display the image in grid row according to their id from DB Actually i am new in this field.So i dont have theoretical concept.

Hi Kedar,it's nice to hear that you like this article,but for your question truly speaking i read your query many time but i am unable to understand what do you exactly want to do?I request you to please elaborate it clearly and then post it in forum section,i ll try to definitely help you.Thnaks

Hi I read your article its really nice one. I have a question. If you go thru the article of the following link and in the end the data is added using the textboxes or edited using them. -- http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/update-records-of-a-table-through-differente-page-in-Asp-Net/ -- Can u help me in designing a form where i have to make a sales invoice where i have to add multiple items, but i have to select proper packaging of the item. It will be like this...Select :-- Item Name, then add all companies which provide this item in select company combo box and in combobox leave event popup a window with a query like item + company (the result will give the details about item with different packaging like 1 lit,2 lit or 5 lit bottles. and select one from it and update into datagrid. Just need about how i should arrange these things using textbox grids (for showing and updating)in desktop application in c#

Hi abhimanyu,it's nice to hear that it works for you,i used it to work on the basis of seelcted id ,i fetch selected value in the variable userid.

Thax a lot for this Article it is really helpful for me.Only i didnot get about lable because you have taken it single in designing page with different ID and coded with different id in coding area any way i managed it and running well.if you dont mind can you explain the why u taken "'where id='"+userid+"'"

thx Vithal and Ancel cool,where r u getting this error,in delete section or in update section,did you modified the code for some data according to you to your requirement such as table name fields and so on??

I get error T_T this sintak cant read, but nothing error msg in VS.. [quote] da.Fill(ds); [/quote] msg.. Incorrect syntax near 'tabelform'. why ? :(