protected void load_ManuID() { string connectionstring = ConfigurationManager.ConnectionStrings["pktphonedata"].ConnectionString; SqlConnection conn = new SqlConnection(connectionstring); string sql = "select* from NhaSanXuat order by MaSX"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); ManuID.DataTextField = "TenSX"; ManuID.DataValueField = "MaSX"; ManuID.DataSource = reader; ManuID.DataBind(); reader.Close(); SqlDataAdapter adapter; adapter = new SqlDataAdapter("select* from NhaSanXuat where MaSX<>'SX00' order by MaSX", conn); DataTable dt = new DataTable(); adapter.Fill(dt); adapter.Dispose(); listsx.DataSource = dt.DefaultView; listsx.DataBind(); conn.Close(); //search_click.NavigateUrl = "sanpham.aspx?key=" + key.Text; if (Session["namecus"] != null) { name.Text = Session["namecus"].ToString().Split(' ')[Session["namecus"].ToString().Split(' ').Length - 1]; home.NavigateUrl = "khachhang_home.aspx"; exit.NavigateUrl = "index.aspx?action=exit"; login.Visible = false; } else { home.Visible = false; exit.Visible = false; login.Visible = true; login.NavigateUrl = "dangky.aspx"; } if (Request.QueryString["action"] != null) { Session.Remove("namecus"); Session.Remove("idcus"); Response.Redirect("index.aspx"); } // Search search_click.NavigateUrl = "sanpham.aspx?manu=" + ManuID.SelectedValue + "&pricef=" + PriceFrom.SelectedValue + "&pricet=" + PriceTo.SelectedValue + "&key=" + key.Text; }
protected void load_ManuID() { string connectionstring = ConfigurationManager.ConnectionStrings["pktphonedata"].ConnectionString; SqlConnection conn = new SqlConnection(connectionstring); string sql = "select* from NhaSanXuat order by MaSX"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); ManuID.DataTextField = "TenSX"; ManuID.DataValueField = "MaSX"; ManuID.DataSource = reader; ManuID.DataBind(); reader.Close(); conn.Close(); }