retrieving data

[ahsan2011]

hii..i m trying to access a database using the foll code..

private void Page_Load(object sender, System.EventArgs e)
 
SqlConnection con;
SqlDataReader dr;
SqlCommand cmd;
con = new SqlConnection("Server=ADNAN;Database=system;UID=sa;pwd=");
cmd = new SqlCommand("Select * from info",con);
con.Open();
dr= cmd.ExecuteReader();
Repeater1.DataSource= dr;
Repeater1.DataBind();
dr.Close();
con.Close();
 

the error which i get is
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

when i remove the user id and the password from the connection, recieves a msg "Login failed for user 'ADNAN\ASPNET"

[Frinavale]

hii..i m trying to access a database using the foll code..

private void Page_Load(object sender, System.EventArgs e)
 
SqlConnection con;
SqlDataReader dr;
SqlCommand cmd;
con = new SqlConnection("Server=ADNAN;Database=system;UID=sa;pwd=");
cmd = new SqlCommand("Select * from info",con);
con.Open();
dr= cmd.ExecuteReader();
Repeater1.DataSource= dr;
Repeater1.DataBind();
dr.Close();
con.Close();
 

the error which i get is
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

when i remove the user id and the password from the connection, recieves a msg "Login failed for user 'ADNAN\ASPNET"

You're connection string should look like:

concStr="data source=<nameOfDatabaseServer>;initial catalog=<nameOfDatabase>;user id=<databaseUserId>;password=<passwordForDatabaseUser>"
 

Hope this helps

-Frinny