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"; }