这个是页面上的GridView可以正常显示
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:sampleConnectionString %>"
SelectCommand="SELECT * FROM [test]"></asp:SqlDataSource>
这个是.cs中的手写连接:
SqlConnection con = new SqlConnection();
con.ConnectionString = "server=wengyuli/sqlexpress;database=sample;uid=sa;pwd=123;";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from test", con);
DataSet ds = new DataSet();
sda.Fill(ds);
TextBox1.Text += ds.Tables[0].Rows[0][0].ToString();手写的提示说无法打开到 SQL Server 的连接
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:sampleConnectionString %>"
SelectCommand="SELECT * FROM [test]"></asp:SqlDataSource>
这个是.cs中的手写连接:
SqlConnection con = new SqlConnection();
con.ConnectionString = "server=wengyuli/sqlexpress;database=sample;uid=sa;pwd=123;";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from test", con);
DataSet ds = new DataSet();
sda.Fill(ds);
TextBox1.Text += ds.Tables[0].Rows[0][0].ToString();手写的提示说无法打开到 SQL Server 的连接
连接方法:"server=wengyuli\\sqlexpress;database=sample;uid=sa;pwd=123"
不知道为什么,以前是用:server=wengyuli\sqlexpress;就可以的,现在在vs2008里就将一个\作转义符号对待了。
con.ConnectionString = "server=wengyuli/sqlexpress;database=sample;uid=sa;pwd=123;";
改成
SqlConnection con = new SqlConnection("server=wengyuli/sqlexpress;database=sample;uid=sa;pwd=123;");
试试 。。
server=wengyuli/sqlexpress; 改成 server=wengyuli\sqlexpress;
server=wengyuli/sqlexpress; 改成 server=wengyuli\sqlexpress;