初学者asp.net/c#连接并查询sql server2005的小例子所出现的问题
<%@ Import Namespace="System.Data" %><%@ Import NameSpace="System.Data.SqlClient" %>
<script language="c#" runat="server">
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection myConnection = New SqlConnection("server=PC-201101031142\SQLEXPRESS;uid=sa;pwd=aaa;database=test");
myConnection.Open()
la1.text="Connection Opened!"
SqlCommand myCommand = New SqlCommand( "select * from [testtable]", myConnection )
MyDataGrid.DataSource=myCommand.ExecuteReader()
MyDataGrid.DataBind()
}
</script>
<html>
<body>
<asp:label id="la1" runat="server" /><br>
<ASP:DataGrid id="MyDataGrid" runat="server"
BorderColor="black"
BorderWidth="1"
GridLines="Both"
CellPadding="3"
CellSpacing="0"
Font-Name="Verdana"
Font-Size="10pt"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
>
</asp:DataGrid>
</body>
</html>
--------------------编程问答-------------------- 什么问题
--------------------编程问答-------------------- SqlConnection myConnection = New SqlConnection(@"server=PC-201101031142\SQLEXPRESS;uid=sa;pwd=aaa;database=test"); --------------------编程问答-------------------- 这段代码提示错误。 SqlConnection myConnection = New SqlConnection("server=PC-201101031142\SQLEXPRESS;uid=sa;pwd=aaa;database=test");
--------------------编程问答-------------------- 谢谢二楼的朋友,我按照你的改了一下,还是提示这行有错误。 --------------------编程问答-------------------- Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True;Provider=SQLOLEDB"
详细信息 --------------------编程问答--------------------
兄弟,帮人帮到底,我是初学者,有些地方看的不太明白。能不能按照我的程序再结合你的这段代码,帮我写一下正确的,给您添麻烦了。 --------------------编程问答--------------------
string con= "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\test.mdf;uid=sa;pwd=aaa;";
SqlConnection conn = new SqlConnection(con);
--------------------编程问答-------------------- <%@ Import Namespace="System.Data" %>
<%@ Import NameSpace="System.Data.SqlClient" %>
<script language="c#" runat="server">
protected void Page_Load(object sender, EventArgs e)
{
string con= "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\test.mdf;uid=sa;pwd=aaa;";
SqlConnection con = new SqlConnection(con);
con.Open() ;
la1.text="Connection Opened!";
SqlCommand myCommand = New SqlCommand( "select * from [testtable]", con );
MyDataGrid.DataSource=myCommand.ExecuteReader();
MyDataGrid.DataBind();
}
</script>
<html>
<body>
<asp:label id="la1" runat="server" /><br>
<ASP:DataGrid id="MyDataGrid" runat="server"
BorderColor="black"
BorderWidth="1"
GridLines="Both"
CellPadding="3"
CellSpacing="0"
Font-Name="Verdana"
Font-Size="10pt"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
>
</asp:DataGrid>
</body>
</html>
谢谢楼上的朋友,改成这样了,又提示 SqlCommand myCommand = New SqlCommand( "select * from [testtable]", con );
这行有错误。朋友们,再帮忙看看吧。谢谢了。 --------------------编程问答-------------------- 顶一下,再线等。 --------------------编程问答-------------------- 等什么
初学者 ADO.net的东西学好了再操作数据库
否则就先把 HTML 练熟 --------------------编程问答--------------------
+1
补充:.NET技术 , ASP.NET