Insert,Update and Delete data in GridView using the Database (SQL)

Step 1: Firstly open the Sql server and create the database and table in it,The table must have a primary key for which we can update and delete the data in gridview.



Step 2 : Now open the Visual Studio 2010 and click File->New->Web site->Select the ASP.net website and then click ok.



Step 3: In The designing view add buttons,textboxes,gridview,labels as shown in the following figure.



Step 4: Double click on the page and write the following code in it.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class Default2 : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("server=.;database=db;uid=sa;pwd=wintellect");
SqlDataAdapter da;
SqlCommand cmd;
DataSet ds = new DataSet();
SqlDataReader dr;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
show();
}
}
public void show()
{
da = new SqlDataAdapter("select * from employee", con);
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}

Step 5: Double click on the insert button and write the following code in the button click event.

protected void Button1_Click(object sender, EventArgs e)
{
string str = "insert into employee values(@emp_id,@emp_name,@emp_salary)";
cmd = new SqlCommand(str, con);
cmd.Parameters.AddWithValue("@emp_id", TextBox1.Text);
cmd.Parameters.AddWithValue("@emp_name", TextBox2.Text);
cmd.Parameters.AddWithValue("@emp_salary", TextBox3.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
show();
Response.Write("Record Inserted");
}