---
title: "How to Add, Edit, Update Records In asp.net"
description: "How to Add, Edit, Update Records In asp.net"
author: "Simond Gear"
published: 2017-01-03
updated: 2017-01-03
canonical: https://www.mindstick.com/forum/34228/how-to-add-edit-update-records-in-asp-dot-net
category: "c#"
tags: ["c#"]
reading_time: 4 minutes
---
# How to Add, Edit, Update Records In asp.net
Hi Guys\
I am [beginner](https://www.mindstick.com/forum/23159/need-beginner-project-ideas) in c# and currently work one of the project.I [am facing](https://answers.mindstick.com/qa/37099/if-i-am-facing-my-thoughts-while-meditating-am-i-meditating-wrong) a [problem](https://yourviews.mindstick.com/view/81399/tackling-the-problem-of-unemployment-during-corona-pandemic) to show records in [gridview](https://www.mindstick.com/articles/873/update-delete-edit-gridview-in-asp-dot-net) and edit and [update records](https://www.mindstick.com/forum/158986/how-to-update-records-using-entity-framework-core) without refersing.Please help me.\
I would really appreciate your help.\
Thanks\
\
\
## Replies
### Reply by Manish Kumar
**make sql table taking id as primary key and identity specification yes****\****then design html form and add ajax code like this**
```
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="test.WebForm1" %>
```
\
**for bind grid use this code**
```
void bind() { DataSet ds = new DataSet(); using (SqlConnection con = new SqlConnection(@"Data
Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial
Catalog = testdata")) { con.Open(); SqlCommand cmd = new SqlCommand("select * from
EmpDetail", con); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); con.Close(); grid1.DataSource = ds; grid1.DataBind(); } }
```
```
For saving records in database
```
```
protected void submit_Click1(object sender, EventArgs e)
{
SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = @"Data
Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial
Catalog = testdata;"Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;InitialCatalog = testdata;";
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert into
EmpDetail values('"EmpDetail values('"+ EmpName.Text + "','"+ FName.Text + "','"+ email.Text + "','"+ mobile.Text + "')";
cmd.Connection = cnn;
int i = cmd.ExecuteNonQuery();
if (i == 1)
message.Text = "Saved
Succesfully!!"Succesfully!!";
else
message.Text = "Error in
saveing!!! try again!!"saveing!!! try again!!";
bind();
}
```
```
```
```
for deleting and eding record throuh grid view
```
```
protected void grid1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
string Id =
grid1.DataKeys[e.RowIndex].Values[grid1.DataKeys[e.RowIndex].Values["Id"].ToString();
SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = @"Data
Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial
Catalog = testdata;"Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;InitialCatalog = testdata;";
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText="delete from
EmpDetail where Id='"EmpDetail where Id='"+Id+"' ";
cmd.Connection = cnn;
int i =
cmd.ExecuteNonQuery();cmd.ExecuteNonQuery();
if (i == 1)
{
bind();
message.Text = "Record
deleted"deleted";
}
else
{
message.Text = "error";
}
}
catch (Exception ex)
{
message.Text =ex.Message.ToString();
}
}
<--for clearing textboxes after submitting records-->
protected void ClearInputs(ControlCollection ctrls)
{
foreach (Control ctrl in ctrls)
{
if (ctrl is TextBox)
((TextBox)ctrl).Text = string.Empty;
ClearInputs(ctrl.Controls);
}
}
protected void grid1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
submit.Visible = false;
update.Visible = true;
string Id = grid1.DataKeys[e.RowIndex].Values["Id"].ToString();
SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = @"Data
Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial
Catalog = testdata;"Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;InitialCatalog = testdata;";
cnn.Open();
SqlCommand cmd = new SqlCommand("select *
from EmpDetail where Id="from EmpDetail where Id=" + Id, cnn);
SqlDataReader dr =
cmd.ExecuteReader();cmd.ExecuteReader();
if (dr.HasRows == true)
{
dr.Read();
id.Text = dr["Id"].ToString();
EmpName.Text = dr["UserName"].ToString();
FName.Text = dr["FName"].ToString();
email.Text = dr["Email"].ToString();
mobile.Text = dr["Mobile"].ToString();
dr.Close();
cnn.Close();
}
}
```
---
Original Source: https://www.mindstick.com/forum/34228/how-to-add-edit-update-records-in-asp-dot-net
Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.