Databases Reference
In-Depth Information
Figure 8-13.
Changing the GridView's Data Source property
Open the
web.config
file, and enter your connection string. You need to add a
connectionStrings
node under the
configuration
node, as shown in the following example:
4.
<connectionStrings>
<add
name="Connection1"
providerName="System.Data.SqlClient"
connectionString="Server=tcp:yourServer.database.windows.net;
Database=yourDatabase;User ID=test@yourServer;
Password=yourPasswordHere;
Trusted_Connection=False;Encrypt=True;"/>
</connectionStrings>
■
Note
Make sure to specify the user id as
<user name>@<server name>
.
