初学者asp.net/c#连接并查询sql server2005的小例子所出现的问题

aslipeng 2011-01-03 08:25:41

<%@ 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>

...全文

90 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

moxiaomomo 2011-05-08

打赏
举报

[Quote=引用 10 楼 fengyarongaa 的回复:]
等什么
初学者 ADO.net的东西学好了再操作数据库
否则就先把 HTML 练熟
[/Quote]
+1

ycproc 2011-01-04

打赏
举报

等什么
初学者 ADO.net的东西学好了再操作数据库
否则就先把 HTML 练熟

aslipeng 2011-01-03

打赏
举报

顶一下，再线等。

aslipeng 2011-01-03

打赏
举报

<%@ 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 );
这行有错误。朋友们，再帮忙看看吧。谢谢了。

wuyq11 2011-01-03

打赏
举报

string con= "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\test.mdf;uid=sa;pwd=aaa;";
SqlConnection conn = new SqlConnection(con);

aslipeng 2011-01-03

打赏
举报

[Quote=引用 5 楼 wuyq11 的回复:]
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;Integrated Se……
[/Quote]

兄弟，帮人帮到底，我是初学者，有些地方看的不太明白。能不能按照我的程序再结合你的这段代码，帮我写一下正确的，给您添麻烦了。

wuyq11 2011-01-03

打赏
举报

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"

详细信息

aslipeng 2011-01-03