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();
}
