cascaded dropdown list box.

[Kunal P]

cascaded dropdown listbox hi. i am developing a web based application in Visual WeB Developer EXPRESS. I have a Drop down list that which is statically filled. Now i wanted that wen i select a particular field from the Drop Down List, a table of the same name shud be accessed, and a particular column be filled in the Listbox Control. i wrote a piece of code try { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "Select * from [" + DropDownList1.SelectedValue + "]";+ "'"; SqlDataReader dread = cmd.ExecuteReader(); dread.Read(); while (dread.Read()) { ListBox1.Items.Add(dread["column_name"].ToString()); } conn.Close(); the problem is that no row is being retrieved.. please help..

Kunal Piyush

[Chris Buckett]

cmd.CommandText = "Select * from [" + DropDownList1.SelectedValue + "]";

• "'";

If you've just copied and pasted, then you have 2 statements on the one line. the final +"'"; is a separate statement from the cmd.CommandText .... "]"; statement Have you tried running your code by entering in a complete dummy sql string just to check it works rather than using the dropdownlist.selectedvalue?

ChrisB ChrisDoesDev[^]

[Kunal P]

this is how it is.. it was probably due to modification.. that there was an other statement. cmd.CommandText = "Select * from [" + DropDownList1.SelectedValue + "]"; i checked with a dummy string.. no retrieval. also wen i had a string like this cmd.CommandText = "Select * from '" + DropDownList1.SelectedValue + "'"; it showed an error.. Incorrect syntax near [valuename]

Kunal Piyush