|
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
|