Insert, update,delete Using 3 tier in asp.net c#
step 1. Create a new website ...
new default page..
step 2.Go to solution explorer add new item. Add class and give name DAL it will ask for create new app_code click on yes it will automatic add a new folder.
It will look like this after click on yes
Step :3 Repeat Step 2 And Give the Name BAL.
Step:4.Design Your Page
Step 5: In DAL File
Write that code You can difine your all logic here and also connection string
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
/// <summary>
/// Summary description for dal
/// </summary>
public class dal
{
SqlCommand cmd;
SqlConnection con;
SqlDataAdapter da;
DataSet ds;
public dal()
{
con = new SqlConnection(@"Data Source=TOPS-222\SQLEXPRESS;Initial Catalog=mytestdb;Integrated Security=True");
}
public DataSet disp()
{
cmd = new SqlCommand("disp",con);
cmd.CommandType = CommandType.StoredProcedure;
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
return ds;
}
public void insert(bal bl)
{
cmd = new SqlCommand("inserts", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("name",bl.name);
cmd.Parameters.AddWithValue("age", bl.age);
cmd.Parameters.AddWithValue("city", bl.city);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void update(bal bl)
{
cmd = new SqlCommand("updates", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("id",bl.id);
cmd.Parameters.AddWithValue("name", bl.name);
cmd.Parameters.AddWithValue("age", bl.age);
cmd.Parameters.AddWithValue("city", bl.city);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void delete(int a)
{
cmd = new SqlCommand("deletes", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("id", a);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
step 6:-In BAL File Create property and the create the DAL Object here.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
/// <summary>
/// Summary description for bal
/// </summary>
public class bal
{
public int id { get; set; }
public string name { get; set; }
public int age { get; set; }
public string city { get; set; }
dal dl = new dal();
public DataSet disp1()
{
return dl.disp();
}
public void insert1(bal bl)
{
dl.insert(bl);
}
public void update1(bal bl)
{
dl.update(bl);
}
public void delete1(int a)
{
dl.delete(a);
}
}
Step:7
.Default.aspx.cs Code File Write That Code..
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
bal bl = new bal();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
disp();
}
}
public void disp()
{
GridView1.DataSource = bl.disp1();
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
bl.name = TextBox1.Text;
bl.age = int.Parse(TextBox2.Text);
bl.city = TextBox3.Text;
bl.insert1(bl);
disp();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int a = int.Parse(((Label)GridView1.Rows[e.RowIndex].FindControl("Label1")).Text);
bl.delete1(a);
disp();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
disp();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
disp();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
bl.id = int.Parse(((Label)GridView1.Rows[e.RowIndex].FindControl("Label1")).Text);
bl.name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text;
bl.age = int.Parse(((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3")).Text);
bl.city = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4")).Text;
bl.update1(bl);
GridView1.EditIndex = -1;
disp();
}
}
...
If you have any query then contact me
