protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["DXC"].ConnectionString);
cmd = new SqlCommand("Select Id,Name,Price,Description,ProductImage from Prod", con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
dt = new DataTable();
dt.Load(reader);
DlProd.DataSource = dt;
DlProd.DataBind();
}
//private SqlConnection con = null;
//private SqlCommand cmd = null;
//private DataTable dt = null;
protected void Page_Load(object sender, EventArgs e)
{
AdminPageService admin = new AdminPageService();
DataSet ds = admin.GetProductDisplay();
//con = new SqlConnection(ConfigurationManager.ConnectionStrings["DXC"].ConnectionString);
//cmd = new SqlCommand("Select Id,Name,Description,Price,ProductImage from Prod", con);
//con.Open();
//SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
// dt = new DataTable();
// dt.Load(reader);
DlProd.DataSource = ds;
DlProd.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["DXC"].ConnectionString);
cmd = new SqlCommand("Select * from Prod where Name='Jeans'", con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
DlProd.DataSource = dt;
DlProd.DataBind();
cmd.Dispose();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
string name = Request.QueryString["id"].ToString();
con = new SqlConnection(ConfigurationManager.ConnectionStrings["DXC"].ConnectionString);
cmd = new SqlCommand("usp_SearchProd", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", name);
con.Open();
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
dt = new DataTable();
dt.Load(rd);
int rows = dt.Rows.Count;
DlProd.DataSource = dt;
DlProd.DataBind();
LblMessage.Text = rows + " Items found";
}
