Chapter 3:连接到SQL Server服务器
连接字符串:
Data Source =./SQLExpress;AttachDbFileName=|DataDirectory|/MyDataFileName.
mdf;Integrated Security=True;User Instance=true
使用SqlDataSource控件:
<asp:SqlDataSource ID="MySourceControlName" Runat="server"
connectionString="
Data Source=./SQLExpress;
AttachDbFileName=|DataDirectory|/MyDataFileName.mdf;
Integrated Security=True;
User Instance=true"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT Field1, [Field With Space] FROM MyTable">
</asp:SqlDataSource>
调用存储过程:
ConnectionString="..."
SelectCommandType="StoredProcedure"
SelectCommand="MySproc"
示例:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="DataSource=./SQLEXPRESS;
AttachDbFilename=|DataDirectory|/Northwind.mdf;
Integrated Security=True;
User Instance=True"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT [ProductID], [ProductName], [UnitPrice]
FROM [Products]">
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False"
DataKeyNames="ProductID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="ProductID" HeaderText="ProductID"
InsertVisible="False"
ReadOnly="True"
SortExpression="ProductID" />
<asp:BoundField DataField="ProductName"
HeaderText="ProductName"
SortExpression="ProductName" />
<asp:BoundField DataField="UnitPrice"
HeaderText="UnitPrice"
SortExpression="UnitPrice" />
</Columns>
</asp:GridView>
使用web.config中的连接:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MdfNorthwind %>"
SelectCommand="SELECT [ProductID], [ProductName], [UnitPrice]
FROM [Products]">
</asp:SqlDataSource>
在web.config中设置连接:
<?xml version="1.0"?> ...
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
<connectionStrings>
... perhaps some other connection strings ...
<add name="MdfNorthwind" connectionString="Data Source=./SQLEXPRESS;
AttachDbFilename=|DataDirectory|/Northwind.mdf;
Integrated Security=True;
User Instance=True"
providerName="System.Data.SqlClient"/>
</connectionStrings>