namespace DataAccessLayer
{
public class clsDL
{
string conn = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
public object ExecuteSqlString(string sqlstring)
{
SqlConnection objsqlconn = new SqlConnection(conn);
objsqlconn.Open();
DataSet ds = new DataSet();
SqlCommand objcmd = new SqlCommand(sqlstring, objsqlconn);
SqlDataAdapter objAdp = new SqlDataAdapter(objcmd);
objAdp.Fill(ds);
return ds;
}
public object LoadCustomerDB()
{DataSet ds = new DataSet();
string sql = "SELECT * from tbl_Customer order by CustID";
ds = (DataSet)ExecuteSqlString(sql);
return ds;
}
}
}
this is my data layer..
protected void Page_Load(object sender, EventArgs e)
{
objLogic = new clsBL();
GridView1.DataSource = objLogic.LoadCustomer();
GridView1.DataBind();
}
this is mu default aspx pagenamespace BussinessLayer
{
public class clsBL
{
public clsDL objDataLayer = new clsDL();
public object LoadCustomer()
{
return objDataLayer.LoadCustomerDB();
}
}
this is my business layer
how should i get my single data
Jignesh TrivediPosted Mar 25, 2015, 7:08 AM
Ok,
so you mean your query is execute 2 time.
this may due to page load code (include ispostback)
try
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
objLogic = new clsBL();
GridView1.DataSource = objLogic.LoadCustomer();
GridView1.DataBind();
}
}
hope this will help you.
elsit josePosted Mar 25, 2015, 7:01 AM
elsit josePosted Mar 25, 2015, 7:00 AM
Jignesh TrivediPosted Mar 25, 2015, 5:38 AM
we don't under stand the question please provide more information.
Khargesh RajputPosted Mar 25, 2015, 4:40 AM
output of table as two table in a line
please explain