how to insert data in database sql server 2008 with 3 tire Architecture

Suppose you are working with three tier Architecture then just create Two Class file as like Class1.cs and Class2.cs first one Class1.cs contains with Properties of table as like:


Code in Class1.cs

namespace _class1 //also create namespace
{
public class Class1
{
public Class1()
{

}

//create a properties as your table have field
public int Id { get; set; }
public string name { get; set; }
}
}


now write coed in Class2.cs
first declare namespace and used namespace of properties declaration class file:

using System.Data.SqlClient;
using _class1;

namespace _class2
{
public class Class2
{
Class1 c1 = new Class1();
public Class2()
{

}

public void InsertData()
{
SqlConnection cnn = new SqlConnection("Data Source=hoth;Initial Catalog=Chintan;User ID=sa");
cnn.Open();
SqlCommand cmd = new SqlCommand("Insert into tbl_data values(@name)",cnn);
cmd.Parameters.AddWithValue("@name",c1.name); //c1.name access from property class file
cmd.ExecuteNonQuery();
cnn.Close();
}
}
}


Now create object of both class file in code behind file as below given code:

namespace _class1;
namespace _class2;

public partial class Default7 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
Class1 c1 = new Class1();
Class2 c2 = new Class2();

c1.name = txtname.text;

c2.InsertData(c1);

lblmessage.text = "Record Inserted Successfully....!!!";
}
}


I hope its helpful to you

Example:

bal_Attendance obj = new bal_Attendance(); //public//

button()
{

obj.branch_id = int.Parse(ddlbranch.SelectedItem.Value);
                   obj.date = dt.ToShortDateString();
                   obj.attendance = status.ToString();
                   obj.employee_id = int.Parse(e_id.Text);
                   obj.employeename = e_name.Text;

}