problem in select query in c#

[suma reddy]

con.open();
string str="select * from table1 where no="+int32.parse(txtno.text)+"";
sqlcommand com=new sqlcommand(str,con);
com.executenonquery();
con.close();

wats the problem in this code i am not getting any error but its not working

[Leito]

Please provide more information on the error if you want us to help you.

What is the error message and what is the line it is appearing on?

[suma reddy]

i am not getting any error msg but the problem is i cant fetch the data from database

[Rabbit]

You didn't define your con variable. You should also output the sql string to make sure it's correct.