ConnectionString =" <%$ConnectionStrings:server=(local);Integrated Security=SSPI;database=student% >"
上面这种写法用的Web.Config里面的设定,所以连接字符串应该放在Web.Config里面,这里放的是连接字符串的名字
有2种改法:
1.先在Web.Config里面定义连接字符串
<connectionStrings>
<add name="yourConnectionString" connectionString="server=(local);Integrated Security=SSPI;database=student" providerName="System.Data.SqlClient"/>
</connectionStrings>
Web里面改为:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString =" <%$ConnectionStrings:yourConnectionString% >" SelectCommand ="select [st_teacher_id],[st_teacher_name],[st_teacher_college] from st_teacher" > </asp:SqlDataSource >2.直接把连接字符串放在SqlDataSource属性里
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString ="server=(local);Integrated Security=SSPI;database=student" SelectCommand ="select [st_teacher_id],[st_teacher_name],[st_teacher_college] from st_teacher" > </asp:SqlDataSource >试试吧