How to get details from database to asp.net f

Closed
sunny - May 11, 2010 at 02:37 AM
 nithin - May 11, 2010 at 07:22 AM
suppose


name ------textbox
no--textbox


how to get these details from sqlserver2005 to aspx form



reply urgent??????????

1 response

1.connect sql from asp using sqlconnection class
2.open the connection
3.query using sqlcommand class..select name,no from emp where name=@name and no=@no
4.com.parameters .add("@name",textbox1.text);
5.com.parameters .add("@no",convert.toint32(textbox2.text);
6.read using sqldatareader class
7.close the connection
0