Perform CRUD Operations in GridView Without Using Database in ASP.NET

Govinda Rajulu Yemineni

ASP.NET GridViewCRUD operation in GridView

17 Comments

Join the conversation! Your thoughts help the community grow.

Akshay P7y ago
How to update Empid without setting it to auto-increment, my empid is not getting updated in edit mode and remaining all fields are getting updated
romil silwal8y ago
How can we do his same for repater instead of gridview
Yashwanth Muthineni11y ago
Nice Share
Santhakumar Munuswamy11y ago
Good one
Shridhar Sharma11y ago
good one
Chervine Bhiwoo11y ago
Nice Article
Govinda Rajulu Yemineni11y ago
Thank you all
Vipul Malhotra11y ago
nice Article
Sibeesh Venu11y ago
Nice Share
Rahul Prajapat11y ago
Good one
Rakesh11y ago
nice one
Gowtham K11y ago
Good one
Nilesh Jadav11y ago
Nice one sir
Upendra Pratap Shahi11y ago
nice share..
Vaikesh K P11y ago
Good one
mahesh patidar11y ago
Nice but i am unable to update the row using the above code. am i doing somthing wromg...
Rajeesh Menoth11y ago
Nice Share

In this article, I will explain how to insert, edit, update and delete records in a GridView without a database in ASP.NET.

Go to Start, then All Programs and open Microsoft Visual Studio 2013.
Now, click on File, then select New Project and click on Visual C#. Then select ASP.NET Web Application, Empty and click on OK.
Provide the web application name and location as you wish. I named my web application InsertEditUpdateDeleteGridviewWithOutDB.
Now the project will be opened. Right-click on the web application name, add a New Item and select Web Form. Then click on Add.
Add the following code between the <form> tags of the WebForm1.aspx page.
1. <div align="center">
2. <table>
3. <tr>
4. <td>EmpId</td>
5. <td>
6. <asp:TextBox ID="txtEmpId" runat="server" />
7. </td>
8. </tr>
9. <tr>
10. <td>EmpName</td>
11. <td>
12. <asp:TextBox ID="txtEmpName" runat="server" />
13. </td>
14. </tr>
15. <tr>
16. <td>EmpSalary</td>
17. <td>
18. <asp:TextBox ID="txtEmpSalary" runat="server" />
19. </td>
20. </tr>
21. <tr>
22. <td>Department</td>
23. <td>
24. <asp:TextBox ID="txtDept" runat="server" />
25. </td>
26. </tr>
27. </table>
28. <br />
29. <asp:Button ID="btnInsert" runat="server" Text="Insert" Height="30" Width="70" OnClick="btnInsert_Click" OnClientClick="return validate();" />
30. <br /><br />
31. <asp:GridView ID="GridView1" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White" runat="server" AutoGenerateColumns="false" OnRowEditing="GridView1_RowEditing">
32. <Columns>
33. <asp:BoundField DataField="EmpId" HeaderText="EmpId" ReadOnly="true" />
34. <asp:BoundField DataField="EmpName" HeaderText="EmpName" />
35. <asp:BoundField DataField="EmpSalary" HeaderText="EmpSalary" />
36. <asp:BoundField DataField="Dept" HeaderText="Department" />
37. <asp:TemplateField>
38. <ItemTemplate>
39. <asp:LinkButton Text="Edit" runat="server" CommandName="Edit" />
40. <asp:LinkButton Text="Delete" runat="server" OnClick="OnDelete" />
41. </ItemTemplate>
42. <EditItemTemplate>
43. <asp:LinkButton Text="Update" runat="server" OnClick="OnUpdate" />
44. <asp:LinkButton Text="Cancel" runat="server" OnClick="OnCancel" />
45. </EditItemTemplate>
46. </asp:TemplateField>
47. </Columns>
48. </asp:GridView>
49. </div>

6. Add the following code to the page load event method of the WebForm1.aspx.cs page.

protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.Add("EmpId");
dt.Columns.Add("EmpName");
dt.Columns.Add("EmpSalary");
dt.Columns.Add("Dept");
dt.Rows.Add(1, "JACKSON", 75000, "RESEARCH");
dt.Rows.Add(2, "JOHNSON", 18000, "ACCOUNTING");
dt.Rows.Add(3, "GRANT", 32000, "SALES");
dt.Rows.Add(4, "ADAMS", 34000, "OPERATIONS");
ViewState["dt"] = dt;
BindGrid();
}
}
protected void BindGrid()
{
GridView1.DataSource = ViewState["dt"] as DataTable;
GridView1.DataBind();
}

7. Add the following code to the GridView1_RowEditing event method of the WebForm1.aspx.cs page.

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
BindGrid();
}

8. Add the following code to the OnUpdate event method of the WebForm1.aspx.cs page.

protected void OnUpdate(object sender, EventArgs e)
{
GridViewRow row = (sender as LinkButton).NamingContainer as GridViewRow;
string empname=((TextBox)row.Cells[1].Controls[0]).Text;
int empsal = Convert.ToInt32(((TextBox)row.Cells[2].Controls[0]).Text);
string dept = ((TextBox)row.Cells[3].Controls[0]).Text;
DataTable dt = ViewState["dt"] as DataTable;
dt.Rows[row.RowIndex]["EmpName"] = empname;
dt.Rows[row.RowIndex]["EmpSalary"] = empsal;
dt.Rows[row.RowIndex]["Dept"] = dept;
ViewState["dt"] = dt;
GridView1.EditIndex = -1;
BindGrid();
}

9. Add the following code to the OnCancel event method of the WebForm1.aspx.cs page.

protected void OnCancel(object sender, EventArgs e)
{
GridView1.EditIndex = -1;
BindGrid();
}

10. Add the following code to the OnDelete event method of the WebForm1.aspx.cs page.

protected void OnDelete(object sender, EventArgs e)
{
GridViewRow row = (sender as LinkButton).NamingContainer as GridViewRow;
DataTable dt = ViewState["dt"] as DataTable;
dt.Rows.RemoveAt(row.RowIndex);
ViewState["dt"] = dt;
BindGrid();
}

11. Add the following code to the btnInsert_Click event method of the WebForm1.aspx.cs page.

protected void btnInsert_Click(object sender, EventArgs e)
{
DataTable dt = ViewState["dt"] as DataTable;
dt.Rows.Add(txtEmpId.Text, txtEmpName.Text, txtEmpSalary.Text, txtDept.Text);
ViewState["dt"] = dt;
BindGrid();
txtEmpId.Text = string.Empty;
txtEmpName.Text = string.Empty;
txtEmpSalary.Text = string.Empty;
txtDept.Text = string.Empty;
}

12. Add a <script> tag between the <head> tags and write the following code in it.

<script type="text/javascript">
function validate()
{
var empid = document.getElementById("txtEmpId").value;
var empname = document.getElementById("txtEmpName").value;
var empsalary = document.getElementById("txtEmpSalary").value;
var dept = document.getElementById("txtDept").value;
if(empid=="" || empname=="" || empsalary=="" || dept=="")
{
alert("Fill All the Fields");
return false;
}
else
{
return true;
}
}
</script>

13. Now run the application and you can see it in your browser.

14. Now, insert one record into the GridView.

15. Now, update the Name GRANT of the EmpId 3 record to GRANT ELLIOTT.

16. Now, delete EmpId 4 Record.