dropdownlist

mylogics

hii all... i hav populated the two dropdown lists from database. according to the item selected in the dropdown i want to change the respective textbox value.I hav written code it works for first dropdown but not for second.whenever i change the item in dropdownlist2 it does not show any value in its respective textbox. plz reply.. the code is: protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PopulateDDL1(); PopulateDDL2(); } } public void PopulateDDL1() { SqlCommand cmd = new SqlCommand("Select * From [Vendor]", new SqlConnection(ConfigurationManager.ConnectionStrings["BillingSystem"].ConnectionString)); cmd.Connection.Open(); SqlDataReader dr; dr = cmd.ExecuteReader(); DropDownList1.DataSource = dr; DropDownList1.DataValueField = "VendorID"; DropDownList1.DataTextField = "VendorID"; DropDownList1.DataBind(); cmd.Connection.Close(); } public void PopulateDDL2() { SqlCommand cmd = new SqlCommand("Select * From [Product]", new SqlConnection(ConfigurationManager.ConnectionStrings["BillingSystem"].ConnectionString)); cmd.Connection.Open(); SqlDataReader dr; dr = cmd.ExecuteReader(); DropDownList2.DataSource = dr; DropDownList2.DataValueField = "ProductID"; DropDownList2.DataTextField = "ProductID"; DropDownList2.DataBind(); cmd.Connection.Close(); } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { string str = "Select * From Vendor Where(VendorID='" + DropDownList1.SelectedValue + "')"; SqlCommand cmd = new SqlCommand(str, conn); SqlDataReader dr = null; conn.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { TextBox1.Text = dr["VendorName"].ToString(); } conn.Close(); } protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { string str = "Select * From Product Where(ProductID='" + DropDownList2.SelectedValue + "')"; SqlCommand cmd = new SqlCommand(str, conn); SqlDataReader dr = null; conn.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { TextBox3.Text = dr["ProductName"].ToString(); } conn.Close(); }

padmanabhan N

check whether you have given autopostback property to both the dropdown

Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]

mylogics

yaa i hav made both dropdown autopostback property to true....

mylogics

its not workin yet...

khuzwayom

Is the AutoPostBack property of that dropdown set to True?

MP

DoctorMick

Make sure you have wired the event up properly in your aspx page, i.e. Also, put a breakpoint at the start of your DropDownList2_SelectedIndexChanged method to see if it is being called at all.

mylogics

yaa...

haleemasher

i have done the same thing which u want i just use daset instead of datareader try it

protected void Page\_Load(object sender, EventArgs e)
{
    DAL Helper = new DAL();
 // DataSet ds = new DataSet();
Helper.ConnectionString = "Data Source=.\\\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Coupon Management.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
//  SqlCommand txtcmd = new SqlCommand();
  //  commandText ="'"+txtAmount .AutoPostBack +"'";

    string query = "select CouponName from CouponType";
  ds = Helper.ExecuteDataSet(CommandType.Text, query, null);

  if (!IsPostBack)
  {
      ddlCType.DataSource = ds;
      ddlCType.DataValueField = "CouponName";
      ddlCType.DataTextField = "CouponName";
      ddlCType.DataSourceID = String.Empty;
  }
}

protected DataSet GetData(string sqlCommand)
{

   da1  = new SqlDataAdapter(sqlCommand, cnx );
   ds  = new DataSet();
   da1.Fill(ds );
    return ds ;

}

protected void DropDownList1_TextChanged(object sender, EventArgs e)
{
cnx.Open();
SqlCommand ddlcmd = new SqlCommand();
commandText = "SELECT MAX(CouponTransaction.SerialEnd),CouponType.Price FROM CouponType INNER JOIN CouponTransaction ON CouponType.CouponTypeID = CouponTransaction.CouponTypeID WHERE CouponType.CouponName= '" + ddlCType.SelectedValue + "'GROUP BY CouponType.Price";
ds = new DataSet();
ds = GetData(commandText);
if (ds.Tables[0].Rows.Count!=0 )
{
txtSFrom.Text = ds.Tables[0].Rows[0][0].ToString();
Txtprice.Text = ds.Tables[0].Rows[0][1].ToString();
cnx.Close();
}
}

KhandelwalA

Use google

mylogics

thanks .... ;)

padmanabhan N

your code seems to be fine.... jus check whether u have values in the database...... :)

Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]