how can i connect the database

[snifer]

hi friends
i has a problem when the database of sql sever2005 is connected with asp.net plz send the code urgent

[bobby21]

To connect to the database sqlserver with sql server authentication

sqlconnection cn=new sqlconnection("data source=xxx;database=yyy;user id=sa;password=zzz");
where xxx=server name, yyy= database name, zzz= password for sqlserver while u connect.

if you wanna connect with windows authentication:

sqlconnection cn=new sqlconnection("data source=xxx;database=yyy;trusted_connection=yes");
where xxx=server name, yyy= database name