Emergency

[Shawn Zheng]

I found the problem is the conneciton string seems did not take effect. Does
any one met this problem? I dragged connection string from Server exploer in
Visual Studio into web form. the form in this time only one dropdown list
box. and only one line code that tried to open the connection. I changed the
connection user id to I created login id, but SQL server still use the
blank name to login to the sql server. How do I resolve this?

Shawn

 

[Sam Martin]

where did you change the database login details? (I'm assuming in
InitialiseComponent?)

SqlConnection con = new SqlConnection(<connection_string.);
con.Open();

check out http://www.connectionstrings.com/ for help on connection strings.

HTH
sam

 

[Sam Martin]

also make sure trusted_connection=false (or not present) if you're passing
in username and password