Post
Ask Question

Asp.Net GridView - How to Update Delete Insert in GridView in C#.Net

  .aspx Code: 
  1. <div style="height: 566px; width: 1201px">  
  2. <div style="width:420px; margin-left: 372px; height: 47px;">  
  3. <asp:Label ID="lblView" runat="server" Font-Bold="True" Font-Size="X-Large"  
  4. Font-Underline="True" Text="DOCTOR'S APPROVED LIST"></asp:Label>  
  5. </div>  
  6. <div style="height:63px; width:551px; margin-left: 582px; margin-top: 19px;">  
  7. <div style="height:22px; width:74px; margin-left: 30px; margin-top: 30px; float:left;">  
  8. <asp:HyperLink ID="hlkLog" runat="server" Font-Bold="True"  
  9. NavigateUrl="~/AdminLogin1.aspx">LOGOUT</asp:HyperLink>  
  10. </div>  
  11. <div style="height:22px; width:100px; margin-left: 52px; margin-top: 30px; float:left;">  
  12. <asp:HyperLink ID="hlkMain" runat="server" Font-Bold="True"  
  13. NavigateUrl="~/MainPage.aspx">MAINPAGE</asp:HyperLink>  
  14. </div>  
  15. <div style="height:22px; width:83px; margin-left: 52px; margin-top: 30px; float:left;">  
  16. <asp:HyperLink ID="hlkBack" runat="server" Font-Bold="True"  
  17. NavigateUrl="~/DocPatDetails.aspx">BACK</asp:HyperLink>  
  18. </div>  
  19. </div>  
  20. <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"  
  21. BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px"  
  22. CellPadding="3" CellSpacing="1" GridLines="None"  
  23. style="margin-top: 15px; margin-left: 56px;" Height="236px" Width="1111px" DataKeyNames="code"  
  24. onrowcancelingedit="GridView1_RowCancelingEdit"  
  25. onrowdatabound="GridView1_RowDataBound" onrowdeleting="GridView1_RowDeleting"  
  26. onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating" >  
  27. <Columns>  
  28. <asp:TemplateField HeaderText="CODE">  
  29. <EditItemTemplate>  
  30. <asp:TextBox ID="txtCode" runat="server" Text='<%# Bind("code") %>'></asp:TextBox>  
  31. </EditItemTemplate>  
  32. <ItemTemplate>  
  33. <asp:Label ID="lblCode" runat="server" Text='<%# Bind("code") %>'></asp:Label>  
  34. </ItemTemplate>  
  35. </asp:TemplateField>  
  36. <asp:TemplateField HeaderText="PASSWORD" HeaderStyle-Width="10%">  
  37. <EditItemTemplate>  
  38. <asp:TextBox ID="txtPass" runat="server" Text='<%#Eval("pass") %>'></asp:TextBox>  
  39. </EditItemTemplate>  
  40. <ItemTemplate>  
  41. <asp:Label ID="lblPass" runat="server" Text='<%#Eval("pass") %>'></asp:Label>  
  42. </ItemTemplate>  
  43. <HeaderStyle Width="15%"></HeaderStyle>  
  44. </asp:TemplateField>  
  45. <asp:TemplateField HeaderText="DOCT NAME" HeaderStyle-Width="15%">  
  46. <EditItemTemplate>  
  47. <asp:TextBox ID="txtDocname" runat="server" Text='<%#Eval("dname") %>'></asp:TextBox>  
  48. </EditItemTemplate>  
  49. <ItemTemplate>  
  50. <asp:Label ID="lblDocname" runat="server" Text='<%#Eval("dname") %>'></asp:Label>  
  51. </ItemTemplate>  
  52. <HeaderStyle Width="15%"></HeaderStyle>  
  53. </asp:TemplateField>  
  54. <asp:TemplateField HeaderText="WORK EXP" HeaderStyle-Width="15%">  
  55. <EditItemTemplate>  
  56. <asp:DropDownList ID="ddlWork" runat="server">  
  57. <asp:ListItem>0-5</asp:ListItem>  
  58. <asp:ListItem>5-10</asp:ListItem>  
  59. <asp:ListItem>10-15</asp:ListItem>  
  60. <asp:ListItem>20-25</asp:ListItem>  
  61. <asp:ListItem>25->></asp:ListItem>  
  62. </asp:DropDownList>  
  63. </EditItemTemplate>  
  64. <ItemTemplate>  
  65. <asp:Label ID="lblWexp" runat="server" Text='<%#Eval("wexp") %>'></asp:Label>  
  66. </ItemTemplate>  
  67. <HeaderStyle Width="15%"></HeaderStyle>  
  68. </asp:TemplateField>  
  69. <asp:TemplateField HeaderText="DEPT" HeaderStyle-Width="10%">  
  70. <EditItemTemplate>  
  71. <asp:DropDownList ID="ddlDept" runat="server">  
  72. <asp:ListItem>CARDIOLOGY</asp:ListItem>  
  73. <asp:ListItem>DERMATOLOGY</asp:ListItem>  
  74. <asp:ListItem>DIABETICS</asp:ListItem>  
  75. <asp:ListItem>OPHTHALMOLOGY</asp:ListItem>  
  76. <asp:ListItem>NEPHROLOGY</asp:ListItem>  
  77. <asp:ListItem>DENTIST</asp:ListItem>  
  78. <asp:ListItem>ENT</asp:ListItem>  
  79. <asp:ListItem>PHYSICIAN</asp:ListItem>  
  80. </asp:DropDownList>  
  81. </EditItemTemplate>  
  82. <ItemTemplate>  
  83. <asp:Label ID="lblDept" runat="server" Text='<%#Eval("dept") %>'></asp:Label>  
  84. </ItemTemplate>  
  85. <HeaderStyle Width="10%"></HeaderStyle>  
  86. </asp:TemplateField>  
  87. <asp:TemplateField HeaderText="MOB NO" HeaderStyle-Width="15%">  
  88. <EditItemTemplate>  
  89. <asp:TextBox ID="txtMobno" runat="server" Text='<%#Eval("mobno") %>'></asp:TextBox>  
  90. </EditItemTemplate>  
  91. <ItemTemplate>  
  92. <asp:Label ID="lblMobno" runat="server" Text='<%#Eval("mobno") %>'></asp:Label>  
  93. </ItemTemplate>  
  94. <HeaderStyle Width="15%"></HeaderStyle>  
  95. </asp:TemplateField>  
  96. <asp:TemplateField HeaderText="ADDRESS" HeaderStyle-Width="15%">  
  97. <EditItemTemplate>  
  98. <asp:TextBox ID="txtAdd" runat="server" Text='<%#Eval("address") %>'></asp:TextBox>  
  99. </EditItemTemplate>  
  100. <ItemTemplate>  
  101. <asp:Label ID="lblAdd" runat="server" Text='<%#Eval("address") %>'></asp:Label>  
  102. </ItemTemplate>  
  103. <HeaderStyle Width="15%"></HeaderStyle>  
  104. </asp:TemplateField>  
  105. <asp:TemplateField HeaderText="STATUS">  
  106. <EditItemTemplate>  
  107. <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("status") %>'></asp:TextBox>  
  108. </EditItemTemplate>  
  109. <ItemTemplate>  
  110. <asp:Label ID="Label1" runat="server" Text='<%# Bind("status") %>'></asp:Label>  
  111. </ItemTemplate>  
  112. </asp:TemplateField>  
  113. <asp:TemplateField HeaderText="EDIT/DELETE" HeaderStyle-Width="15%">  
  114. <ItemTemplate>  
  115. <asp:LinkButton ID="btnEdit" Text="Edit" runat="server" CommandName="Edit" />  
  116. <asp:LinkButton ID="btnDelete" Text="Delete" runat="server" CommandName="Delete" />  
  117. </ItemTemplate>  
  118. <EditItemTemplate>  
  119. <asp:LinkButton ID="btnUpdate" Text="Update" runat="server" CommandName="Update" />  
  120. <asp:LinkButton ID="btnCancel" Text="Cancel" runat="server" CommandName="Cancel" />  
  121. </EditItemTemplate>  
  122. <HeaderStyle Width="15%"></HeaderStyle>  
  123. </asp:TemplateField>  
  124. </Columns>  
  125. <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />  
  126. <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />  
  127. <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />  
  128. <RowStyle BackColor="#DEDFDE" ForeColor="Black" />  
  129. <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />  
  130. <SortedAscendingCellStyle BackColor="#F1F1F1" />  
  131. <SortedAscendingHeaderStyle BackColor="#594B9C" />  
  132. <SortedDescendingCellStyle BackColor="#CAC9C9" />  
  133. <SortedDescendingHeaderStyle BackColor="#33276A" />  
  134. </asp:GridView>  
  135. <asp:Label ID="lblMessage" ForeColor="Green" Font-Bold="true" runat="server" Text=""></asp:Label>  
  136. </div>  
aspx.cs 
  1. using System;  
  2. using System.Collections.Generic;  
  3. using System.Linq;  
  4. using System.Web;  
  5. using System.Web.UI;  
  6. using System.Web.UI.WebControls;  
  7. using System.Data.SqlClient;  
  8. using System.Configuration;  
  9. using System.Data;  
  10. public partial class DoctorApprovList : System.Web.UI.Page  
  11. {  
  12.     protected void Page_Load(object sender, EventArgs e)  
  13.     {  
  14.         if (!IsPostBack)  
  15.         {  
  16.             gvbind();  
  17.         }  
  18.     }  
  19.     // Binding datas  
  20.     protected void gvbind()  
  21.     {  
  22.         SqlConnection con = new SqlConnection();  
  23.         con.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString();  
  24.         con.Open();  
  25.         SqlDataAdapter sda = new SqlDataAdapter("Select * from DOC_REG1 where status='T'", con);  
  26.         DataSet ds = new DataSet();  
  27.         sda.Fill(ds);  
  28.         GridView1.DataSource = ds;  
  29.         GridView1.DataBind();  
  30.     }  
  31.     //row deleting  
  32.     protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)  
  33.     {  
  34.         int code = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);  
  35.         SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString());  
  36.         con.Open();  
  37.         string query1 = "delete from DOC_REG1 where code=" + code+ "";  
  38.         SqlCommand cmd = new SqlCommand(query1, con);  
  39.         cmd.ExecuteNonQuery();  
  40.         gvbind();  
  41.         lblMessage.Text = "RECORD DELETED SUCCESSFULLY";  
  42.         con.Close();  
  43.     }  
  44.     protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)  
  45.     {  
  46.         GridView1.EditIndex = e.NewEditIndex;  
  47.         gvbind();  
  48.     }  
  49.     protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)  
  50.     {  
  51.         GridView1.EditIndex = -1;  
  52.         gvbind();  
  53.     }  
  54.     //row databound  
  55.     protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)  
  56.     {  
  57.         DataRowView dRowView = (DataRowView)e.Row.DataItem;  
  58.         if (e.Row.RowType == DataControlRowType.DataRow)  
  59.         {  
  60.             if ((e.Row.RowState & DataControlRowState.Edit) > 0)  
  61.             {  
  62.                 DropDownList ddlWork = (DropDownList)e.Row.FindControl("ddlWork");  
  63.                 DropDownList ddlDept = (DropDownList)e.Row.FindControl("ddlDept");  
  64.                 ddlWork.SelectedValue = dRowView[3].ToString();  
  65.                 ddlDept.SelectedValue = dRowView[4].ToString();  
  66.             }  
  67.         }  
  68.     }  
  69.     //row updating  
  70.     protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)  
  71.     {  
  72.          int code= Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);  
  73.          GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];  
  74.          TextBox txt = (TextBox)row.FindControl("txtPass");  
  75.          string newpass = txt.Text;  
  76.          txt = (TextBox)row.FindControl("txtDocname");  
  77.          string newDocname = txt.Text;  
  78.          DropDownList ddlWork = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlWork");  
  79.          DropDownList ddlDept = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlDept");  
  80.          txt = (TextBox)row.FindControl("txtMobno");  
  81.          int newMob = Convert.ToInt32(txt.Text);  
  82.          txt = (TextBox)row.FindControl("txtAdd");  
  83.          string newaddress = txt.Text;  
  84.          SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString());  
  85.          con.Open();  
  86.          string query = "update DOC_REG1 set pass='" + newpass + "',dname='" + newDocname + "',wexp='" + ddlWork.SelectedValue + "',dept='" + ddlDept.SelectedValue + "',mobno='" + newMob + "',address='" + newaddress + "' where code='" +code+ "'";  
  87.          SqlCommand cmd = new SqlCommand(query, con);  
  88.          cmd.ExecuteNonQuery();  
  89.          GridView1.EditIndex = -1;  
  90.          gvbind();  
  91.          con.Close();  
  92.     }  
  93. }  
In the case of radiobuttonlist,we use codes in the place of dropdownlist as shown below:
  1.    
  2. protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)  
  3. {  
  4.    
  5.       RadioButtonList rblGender= (RadioButtonList)e.Row.FindControl("rblGender");  
  6.       rblGender.SelectedValue = dRowView[2].ToString();  
  7. }  
 And
  1. protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)  
  2. {  
  3.    
  4.     RadioButtonList rblGen= (RadioButtonList)GridView1.Rows[e.RowIndex].FindControl("rblGender");  
  5.    
  6.  }