How to show the data from sql by any chosen value from dropdown menu?

[Fitore]

I have created a database with name algorithmA4 and with atributes ID(primary key), Row (int), State (varchar).
So, I have to chose any number from dropdown menu (in the Row I have added 50 numbers from 1-15)to show the states in an textarea below that contain that number.
For example: I chose number 5, and after I push the button GO should show in the text area (England, Austria, Germany, France,(states that I have in database with this number))

Please help me!

[raghurocks]

use this code..
sqlcommand cmd=new sqlcommand("select state from algorithmA4 where ID=5",connection object);
connectionobj.open();
sqldatareader dr=cmd.executereader();
while(Dr.read())
{
textbox1.text+=dr["state"].tostring()+",";
}
textbox1=textbox1.remove(textbox1.length-1,1);

[raghurocks]

i think this will help you