protected void DPLSELECTVENDORS_SelectedIndexChanged(object sender, EventArgs e)
{
/*cmd.CommandText = " select componentname from quatation where vendorname='"+DPLSELECTVENDORS.SelectedItem.Text+"'";
* string comp = Convert.ToString(cmd.ExecuteScalar());
* TXTCOMPONENT.Text=comp;*/
Session["vendor"] = DPLSELECTVENDORS.SelectedItem.Text;
cmd.CommandText = "select componentname from quatation where vendorname='" + DPLSELECTVENDORS.SelectedItem.Text + "'";
ad1.SelectCommand = cmd;
ad1.Fill(ds1);
/*DPLSELECTVENDOR.DataSource = ds;
* DPLSELECTVENDOR.DataTextField = ds.Tables[0].Columns[0].ToString();
* DPLSELECTVENDOR.DataBind();*/
DPLSELECTCOMPONENT.DataSource = ds1;
DPLSELECTCOMPONENT.DataTextField = ds1.Tables[0].Columns[0].ToString();
DPLSELECTCOMPONENT.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
cmd.Connection = vd.getcon();
if (!IsPostBack)
{
cmd.CommandText = "select name from componentlist";
ad.SelectCommand = cmd;
ad.Fill(ds);
/*DPLSELECTVENDOR.DataSource = ds;
* DPLSELECTVENDOR.DataTextField = ds.Tables[0].Columns[0].ToString();
* DPLSELECTVENDOR.DataBind();*/
DPLSELECTCOMPONENT.DataSource = ds;
DPLSELECTCOMPONENT.DataTextField = ds.Tables[0].Columns[0].ToString();
DPLSELECTCOMPONENT.DataBind();
}
}
