public class DAL
{
public int id { get; set; }
public string uname { get; set; }
public string uaddress { get; set; }
public string uhobby { get; set; }
}

public class BAL
{
SqlConnection con = new SqlConnection( @”Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Program file\3tier\3tier\App_Data\Database1.mdf;IntegratedSecurity=True;User Instance=True“);

public void insert_data(DAL da)
{
con.Open();
SqlCommand cmd = new SqlCommand();

cmd = new SqlCommand(“insert into user_master values(‘” + da.uname + “‘,'” + da.uaddress + “‘,'” + da.uhobby + “‘)”, con);
cmd.ExecuteNonQuery();
con.Close();
}

public DataTable edit_data(DAL da)
{
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(“select * from user_master where uname='” + da.uname + “‘”, con);
sda.Fill(dt);
return dt;
}

public void delete_data(DAL da)
{
con.Open();
SqlCommand cmd = new SqlCommand(“delete from user_master where uname=’” + da.uname + “‘”, con);
cmd.ExecuteNonQuery();
con.Close();
}

public void update_data(DAL da)
{
con.Open();
SqlCommand cmd = new SqlCommand(“update user_master set uaddress='” + da.uaddress +”‘,uhobby='” + da.uhobby + “‘ where uname='” + da.uname + “‘”, con);
cmd.ExecuteNonQuery();
con.Close();
}

public DataTable bind_gridview(DAL da)
{
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(“select * from user_master“, con);
sda.Fill(dt);
return dt;
}
}

public partial class reg : System.Web.UI.Page
{
DAL da = new DAL();
BAL ba = new BAL();
DataTable dt = new DataTable();protected void Page_Load(object sender, EventArgs e)
{
GridView();}
public void GridView()
{
dt=ba.bind_gridview(da);
GridView1.DataSource = dt;
GridView1.DataBind();}

protected void btn_submit_Click(object sender, EventArgs e)
{
da.uname = txtname.Text;
da.uaddress = txtadress.Text;
da.uhobby = Chhobby.SelectedItem.Text;
ba.insert_data(da);
Response.Write(“data inserted…………“);
GridView();}
protected void btn_edit_Click(object sender, EventArgs e)
{
da.uname = txtname.Text;
dt = ba.edit_data(da);
txtadress.Text = dt.Rows[0][“uaddress“].ToString();
Chhobby.SelectedValue = dt.Rows[0][“uhobby“].ToString();GridView();
}
protected void btn_delete_Click(object sender, EventArgs e)
{
da.uname = txtname.Text;
da.uaddress = txtadress.Text;
da.uhobby = Chhobby.SelectedItem.Text;
ba.delete_data(da);
GridView();
}
protected void btn_update_Click(object sender, EventArgs e)
{
da.uname = txtname.Text;
da.uaddress = txtadress.Text;
da.uhobby = Chhobby.SelectedItem.Text;
ba.update_data(da);
Response.Write(“data updated…”);
GridView();
}
}

1. Auto Refresh Partial View in ASP.NET MVC
2. What is ASP.NET Core
3. Difference between TempData keep() And Peek() in Asp.Net MVC
4. Difference between viewbag,viewdata and tempdata in asp.net mvc
5. ASP.NET MVC With AngularJS
6. Retrieving Data Using Form Collection and Inserting Into ASP.Net MVC
7. MVC CRUD Operations Using Entity Framework
8. Search Functionality in ASP.NET MVC
9. How to create a User Registration page using asp.net mvc
10. Store Multiple Checkbox state from cookie using Jquery
11. Cascading Dropdownlist using Ajax in Asp.Net Mvc with city state country
12. Insert, Update, Delete In GridView Using ASP.Net C#
13. Binding Dropdownlist With Database In Asp.Net MVC
14. Search and Filter data in Gridview using Asp.net MVC
15. Select Insert, Update And Delete With ASP.NET MVC
16. Display Data in GridView Using Asp.net MVC
17. Validation in ASP.NET MVC Razor view
18. CRUD Operation Using 3-Tier Architecture In ASP.NET
19. How to get Connection String from Web.Config in Asp.Net C#
20. Login page using 3-Tier Architecture in ASP.Net
21. Asp.Net Image Upload in 3-Tier Architecture and store in sql database