connection with Sql Server

[tolkien]

Hi,i'm new in c# and i want to do this:
I have installed MS Sql server in my pc.
I 'm trying to create a winform which "reads" from a table in a
database and prints its data .
My biggest problem is :how the hell do i connect with the sql
server!!!

The name of the server is TURBOX
the name of the database is MYBUSINESS
the name of the table is SALGRADE

what i wrote is thisI saw it in a tutorial )



string connectionString = "server=TURBOX; database=MYBUSINESS; uid=;
pwd=;";

SqlConnection conn = new SqlConnection(connectionString);

String commandString = "SELECT " + "GRADE,LOSAL,HISAL" + "FROM
SALGRADE";

SqlDataAdapter dataAdapter = new SqlDataAdapter(commandString, conn);




I didn't expect it to work of course
When i run this program i get an exception:

Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.


I don't have a userid or a password
When i connect to the SQL server i use Windowns Authentication.

Any ideas?
Thanks anyway!!!!!!

 

[Marc Gravell]

Try adding ";Integrated Security=True" to the connection string.

For more info of all options:

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx

Marc

 

[Marc Gravell]

For info, if you are using VS pro/team, the "server explorer" or other
data source tools can make light work of this. Curiously it isn't so
well supported in the express edition, but is possible (see previous
post).

Marc

 

[tolkien]

thanks man!!!

 

[tolkien]

Dude ,it worked!!!!!!!!!!!!
thank you very very very much!!

 

[Marc Gravell]

No problem; any other problems / questions, just post a new topic ;-p

Marc