Comments by charan anasam (Top 4 by date)

after googling itself placed question here!anyway what you suggested is really great better to keep on updating it on every post then you will be a platinum member!!

here is my code:
DAL:
public DataSet UserDetailGrid(BEL.BEL objBELUserDetailGrid)
{
con.Open();
SqlCommand cmd = new SqlCommand("Usp_GridUserDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
try
{
DataSet ds = new DataSet();
cmd.Parameters.AddWithValue("@UserName", objBELUserDetailGrid.UserNam);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Close();
return ds;
}
catch (Exception ex)
{
throw ex;
return null;
}
finally
{
cmd.Dispose();
con.Close();
con.Dispose();
}
}
BLL:
public DataSet UserGridDetail(BEL.BEL objUserDetails)
{
DAL.DAL UDGrid = new DAL.DAL();
DataSet ds = UDGrid.UserDetailGrid(objUserDetails);
return ds;
}
InCodeBehind:
protected void BtnDetails_Submit_Click(object sender, EventArgs e)
{
Grd_Details.Visible = true;
BL.BLL objgridviewdetail = new BL.BLL();
BEL.BEL objGUDBEL = new BEL.BEL();
objGUDBEL.UserNam = TxtDetails_UserName.Text;

DataSet ds = objgridviewdetail.UserGridDetail(objGUDBEL);
Grd_Details.DataSource = ds;
Grd_Details.DataBind();
}