Beginning ASP.NET 2.0 and Databases学习笔记（2）

 

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>