Form:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
}
public void Bind()
{
setConnectionString();
query = "select * from userinfo";
DataSet ds = EmpBal.bindgridBAL(query, conString);
GridView1.DataSource = ds;
GridView1.DataBind();
}
Data Layer:
public DataSet bindgridDAL(string query, string conString)
{
try
{
SqlDataAdapter da = new SqlDataAdapter(query,conString);
ds = new DataSet();
da.Fill(ds, "EmpDetail");
da.Dispose();
}
catch (Exception ex)
{
throw ex;
}
return ds;
}
it is for 3 tier architecture.
Business layer:
Public DataSet bindgridBAL(string query, string conString)
{
try
{
return empDAL.bindgridDAL(query, conString);
}
catch (Exception ex)
{
throw ex;
}
}