Sameer Gaikwad net framework Gridview Edit Delete And Update In ASP.NET mesameergaikwad

 Sameer Gaikwad CRUD Operation SQL stored procedure mesameergaikwad

This article was originally published on mesameergaikwad as Sameer Gaikwad net framework Gridview Edit Delete And Update In ASP.NET mesameergaikwad

 

 A GridView is a graphical control element that presents an irregular view of data. A normal Grid View similarly supports some or all of the postdating 

 

 Clicking a column title to change the kind order of the Grid. 

 

 Dragging column heads to change their size and their order. 

 The GridView regulator displays the valuations of a data origin in a table. Each line represents a clearing, while each row represents a history. 

 

 Support to data source controls, similar as SqlDataSource. 

 Support kind capabilities. 

 Support update and cancel capabilities. 

 Support paging capabilities. 

 Support row selection capabilities. 

 Law-behind point access to the GridView object model to stoutly set parcels, handle events, and so on. 

 Numerous crucial fields. 

 Numerous data fields for the hyperlink columns. 

 Tailored style layout through themes and styles using CSS and javascript. 

 The following operations can be performed using GridView control inASP.NET usingC# law before. 

 

 Point to Bind data to GridView column 

 Point to Edit data in GridView 

 Point to Cancel rows from GridView 

 Point to Update row from a database 

 Note 

 

 The most important point that we can get by using GridView events are-RowEditing, RowUpdating, RowDeleting, RowCommand, RowDataBound, RowCancelingEdit, and Pagination. 

 

 Fields 

 

 BoundColumn To control the order and picture of columns. 

 

 HyperLinkColumn Presents the bound data in HyperLink controls 

 

 ButtonColumn Bubbles a stoner command from within a row to the grid event tutor 

 

 TemplateColumn Controls which controllers are gave up in the line 

 

 CommandField Displays Edit, Update, and revoke bangers

 in take to fluxes in the 

. 

 GridView control's EditItemIndex property. 

 

 Details Of Fields 

 

 By explicitly creating a BoundColumn in the Grid's Columns collection, the order and picture of each column can be controlled. In the BoundField parcels, when the DataField and the SortExpressions are given, sorting and rendering the data can be fluently done. 

 

 A HyperLinkColumn presents the bound data in HyperLink controllers. This is generally used to navigate from an item in the grid to a Details view on another runner by directly assigning the runner URL in NavigationUrl or by rendering it from the database. 

 

 With a TemplateColumn, the controllers which are gave up in the file and the data fields bound to the controls can be controlled. By using the TemplateColumn, any type of data control can be fitted. 

 

 The EditCommandColumn is a special column type that supports in- place editing of the data in one row in the grid. EditCommandColumn interacts with another plat of the grid EditItemIndex. By dereliction, the value of EditItemIndex is-1, meaning none of the rows ( particulars) in the grid are beingedited.However, an"edit" button is displayed in the EditCommandColumn for each of the rows in the grid, If EditItemIndex is-1. 

 

 When the"edit" selector is communed, the grid's EditCommand episode is chucked. It's over to the programmer to handle this event in the law. The typical sense sets EditItemIndex to the named row and also rebinds the data to the grid. 

 

 

 When EditItemIndex is set to a particular row, the EditCommandColumn shows"update"and" cancel" buttons for that row ("edit"is still displayed for the other rows). These buttons beget the UpdateCommand and CancelCommand events to be thrown, independently. 

 

 

 

 

 

 PageIndexChanging event occurs when the property of the grid AllowPaging is set to true, and in the law behind the PageIndexChanging event is fired. 

 

 Paging in GridView is allowed by sitting AllowPaging to real. 

 

 Paging in The GridView provides the means to display a group of records from the data source (for illustration, the first 20), and also navigates to the" runner" containing the coming 20 records, and so on through the data. 

 

 When enabled, the grid will display runner navigation buttons either as" coming/ former" buttons or as numeric buttons. When a runner navigation button is clicked, the PageIndexChanged event is thrown. It's over to the programmer to handle this event in the law. 

The GridView fires the RowCommand episode when any push button is pressed. We can give any name as command name, and grounded on that, the check will be done and the circle will be executed. 

 

 The GridView fires the RowCreate episode when a substitute row is created. 

 

 The GridView fires the RowDeleting event when the command name is given as Cancel. 

 

 The GridView fires the RowUpdating episode when the order title is given as Update. 

 

 The GridView fires the RowEditing event when the commandment title is given away as Edit. 

 

 The GridView fires the RowDatabound episode when a data row is bound to data in a GridView control. 

 

 Data in a Grid is generally sorted by clicking the title of the column to sort. Sorting in a DataGrid can be allowed by sitting AllowSorting to real. When enabled, the grid renders LinkButton controls in the title for each column. When the button is clicked, the grid's SortCommand episode is fired. It's over to the programmer to handle this event in the law. Because DataGrid always displays the data in the same order it occurs in the data source, the typical sense sorts the data source and also rebinds the data to the grid. 

 

 

 

 CRUD operation in Gridview 

 CRUD is the short form of Produce, Recoup, Update, and Cancel operation. Produce, Recoup, Update, Cancel operations used in database data operation. Using these 4 operations we can perform insert, elect, modernize, and cancel SQL Garçon Database table data. We'll use these 4 operations in Gridview control in ASP.Net. 

 

 Gridview 

 Gridview control helps to show all SQL garçon table data in the list format. After getting the data from the SQL garçon you have to bind that list with Gridview control. For binding data with Gridview use the following 2 lines 

Gridview1.DataSource = dt;
Gridview1.DataBind();

Now use the following GridView event parcels to perform events similar to an update, cancel, edit cancel, and so on. Let us see what the parcels are 

DataKeyNames This property I've used as the row indicator of GridView 

 OnRowEditing This property is used to handle the event when the stoner clicks on the edit button 

 OnRowCancelingEdit This property is used to handle the event when the stoner clicks on the Cancel button that exists after clicking on the edit button 

 OnRowDeleting This property is used to handle the event when the stoner clicks on the delete button that deletes the row of the GridView 

OnRowUpdating This property is used to handle the event when the stoner clicks on the update button that updates the Grid Record 

 Websites frequently display thousands of data in a GridView in ASP.Net. Generally, the admin can view the registered druggies on the website, but when an admin wants to edit or cancel any fraud or duplicate or damaged data from the table there's a system in GridView to edit, cancel and modernize. See the note section below. 

 

Source Code

2. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
3. 
   
4. <!DOCTYPE html>
5. <html xmlns="http://www.w3.org/1999/xhtml">
6. <head id="Head1" runat="server">
7.     <title>Untitled Page</title>
8.     <style type="text/css">
9.         .Gridview {
10.             font-family: Verdana;
11.             font-size: 10pt;
12.             font-weight: normal;
13.             color: black;
14.         }
15.     </style>
16. </head>
17. <body>
18.     <form id="form1" runat="server">
19.         <div>
20.             <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" EnableModelValidation="True">
21.                 <Columns>
22.                     <asp:BoundField DataField="id" HeaderText="S.No." />
23.                     <asp:BoundField DataField="name" HeaderText="Name" />
24.                     <asp:BoundField DataField="address" HeaderText="address" />
25.                     <asp:BoundField DataField="country" HeaderText="Country" />
26.                     <asp:CommandField ShowEditButton="true" />
27.                     <asp:CommandField ShowDeleteButton="true" />
28.                 </Columns>
29.                 <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
30.                 <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
31.                 <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
32.                 <RowStyle BackColor="White" ForeColor="#003399" />
33.                 <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
34.             </asp:GridView>
35.         </div>
36.         <div>
37.             <asp:Label ID="lblresult" runat="server"></asp:Label>
38.         </div>
39.     </form>
40. </body>
41. </html>
 

Design

The design part will look as in the following image:

Code behind

1. using System;  
2. using System.Configuration;  
3. using System.Data;  
4. using System.Data.SqlClient;  
5. using System.Drawing;  
6. using System.Linq;  
7. using System.Web;  
8. using System.Web.Security;  
9. using System.Web.UI;  
10. using System.Web.UI.HtmlControls;  
11. using System.Web.UI.WebControls;  
12. using System.Web.UI.WebControls.WebParts;  
13. using System.Xml.Linq;  
14. public partial class _Default: System.Web.UI.Page {  
15.     private SqlConnection conn = new SqlConnection("Data Source=NEHASHAMA;Integrated Security=true;Initial Catalog=rp");  
16.     protected void Page_Load(object sender, EventArgs e) {  
17.         if (!IsPostBack) {  
18.             gvbind();  
19.         }  
20.     }  
21.     protected void gvbind() {  
22.         conn.Open();  
23.         SqlCommand cmd = new SqlCommand("Select * from detail", conn);  
24.         SqlDataAdapter da = new SqlDataAdapter(cmd);  
25.         DataSet ds = new DataSet();  
26.         da.Fill(ds);  
27.         conn.Close();  
28.         if (ds.Tables[0].Rows.Count > 0) {  
29.             GridView1.DataSource = ds;  
30.             GridView1.DataBind();  
31.         } else {  
32.             ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());  
33.             GridView1.DataSource = ds;  
34.             GridView1.DataBind();  
35.             int columncount = GridView1.Rows[0].Cells.Count;  
36.             GridView1.Rows[0].Cells.Clear();  
37.             GridView1.Rows[0].Cells.Add(new TableCell());  
38.             GridView1.Rows[0].Cells[0].ColumnSpan = columncount;  
39.             GridView1.Rows[0].Cells[0].Text = "No Records Found";  
40.         }  
41.     }  
42.     protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {  
43.         GridViewRow row = (GridViewRow) GridView1.Rows[e.RowIndex];  
44.         Label lbldeleteid = (Label) row.FindControl("lblID");  
45.         conn.Open();  
46.         SqlCommand cmd = new SqlCommand("delete FROM detail where id='" + Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString()) + "'", conn);  
47.         cmd.ExecuteNonQuery();  
48.         conn.Close();  
49.         gvbind();  
50.     }  
51.     protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {  
52.         GridView1.EditIndex = e.NewEditIndex;  
53.         gvbind();  
54.     }  
55.     protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {  
56.         int userid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());  
57.         GridViewRow row = (GridViewRow) GridView1.Rows[e.RowIndex];  
58.         Label lblID = (Label) row.FindControl("lblID");  
59.         //TextBox txtname=(TextBox)gr.cell[].control[];  
60.         TextBox textName = (TextBox) row.Cells[0].Controls[0];  
61.         TextBox textadd = (TextBox) row.Cells[1].Controls[0];  
62.         TextBox textc = (TextBox) row.Cells[2].Controls[0];  
63.         //TextBox textadd = (TextBox)row.FindControl("txtadd");  
64.         //TextBox textc = (TextBox)row.FindControl("txtc");  
65.         GridView1.EditIndex = -1;  
66.         conn.Open();  
67.         //SqlCommand cmd = new SqlCommand("SELECT * FROM detail", conn);  
68.         SqlCommand cmd = new SqlCommand("update detail set name='" + textName.Text + "',address='" + textadd.Text + "',country='" + textc.Text + "'where id='" + userid + "'", conn);  
69.         cmd.ExecuteNonQuery();  
70.         conn.Close();  
71.         gvbind();  
72.         //GridView1.DataBind();  
73.     }  
74.     protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) {  
75.         GridView1.PageIndex = e.NewPageIndex;  
76.         gvbind();  
77.     }  
78.     protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {  
79.         GridView1.EditIndex = -1;  
80.         gvbind();  
81.     }  
82. }  

Save all or press "Ctrl+S" and hit "F5" to run the page, the page will look as in the following image:

Click on "Edit the GridView", it will display Textboxes in each cell as in the following image:

Edit the value(s) here and click on the Update link, it will update all the data, or to remove it click on the "Delete" link above the image shown.

Note

One note will be helpful for you while describing Columns in GridView if you are using a boundfield then create objects of the control using cells[index] in the rowupdateing event of GridView, but if you are using controls itself like Label or textboxes, etc then use Fincontrol("stringid").