Learn about Quickstart of dotnet2.0 today. In the gridview controls, you need to configure the database connection in Web. config.
The sample contains the following paragraph:
< Configuration >
< Connectionstrings >
< Add name = " Pubs " Connectionstring = " Server = localhost; user id = dot-well; Password = dot-well.com; Integrated Security = true; database = pubs; "
Providername = " System. Data. sqlclient " />
</ Connectionstrings >
This involves the security connection. I don't know about it, so the permission issue occurs during page execution.
What is the problem with this ntegrated security? I need to study ..................
If you know, give me some advice.
After getting your guidance last time, I have been vague about it. Now I have finally figured it out, because if I write the password in the connection string, it will cause security problems, therefore, Windows Integrated Identity Authentication is used, that is, indegrated security. Therefore, there is a problem with the above sentence. You should change it to the following.
Server = DW - Yidao; Integrated Security = True; Database = Pubs
In addition, we can only say that we have done half of the work. Because we are writing a. NET web app, we need to add the account of Asp.net to the SQL statement. Otherwise, the system will prompt that the login fails.
Well, I know so much now ........................