how to create a method with sql in class file

Question

hii all,

 

 

 

i have started to work on 3 tier architecture i have some problem.

 

1) I have a table name is Teamname having some data.

 

with the help of sql query i have retrived the teamname.

 

like 

 already define connection string

string query="Select Teamname from Teamname where status='ACtive'",

 

sqlcommannd cmd=new sqlcommand(query,con);

 

if(con.state==connectionstate.open()

{

con.close()

}

con.open();

sqldatareader dr=cmd.executeReader();

if(dr.hasRows())

{

returns the teamname ?????? this is how to do it

 

}

 

 

 

on another webpage onload I want to Bind it in a grid view

 

 

so how to do it. suggest me write appropriate code.

 

 

 

thanks in advance