databound controls

[Kunal P]

hi. i am developing a web based application in Visual WeB Developer EXPRESS. I have a Drop down list that which is databound to a particular table. Now i want 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 hope i am clear..

Kunal Piyush

[Sylvester george]

Write a Stored procedure with argumnet (dropdownlist value) call the stored procedure by passing the value inseide the stored procedure write a select query with condition bind the output of stored procedure with listbox

Regards, Sylvester G Senior Software Engineer Xoriant Solutions sylvester_g_m@yahoo.com Score it if you like my post

[Kunal P]

hey never wrote a stored procedure.. all i do is simply specify the query within the code.. and get it executed.. so could you please elaborate on this. sorryy..

Kunal Piyush

[Kunal P]

hi i wrote this piece of code... and i am getting a error stating.. "Invalid Syntax near [valuename]" string connString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["diag"].ConnectionString; SqlConnection conn = new SqlConnection(connString); 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["TestName"].ToString()); } conn.Close(); } catch(Exception ex) { failed.Text = ex.Message; }

Kunal Piyush

[Sylvester george]

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

Regards, Sylvester G sylvester_g_m@yahoo.com

[Kunal P]

sylvesterg wrote:

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

i tried it.. now the error is not coming.. but still no retrival of rows to the listbox as well..

Kunal Piyush