asp.net +sql server
如以下代码:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oCmd As Data.SqlClient.SqlCommand
Dim strConn As String strConn &= "Data source=(local);"
strConn &= "initial catalog=gzgl;"
strConn &= "user id=sa;"
strConn &= "password=lifan;" oCmd = New Data.SqlClient.SqlCommand
oCmd.Connection = New Data.SqlClient.SqlConnection(strConn)
oCmd.Connection.Open()
oCmd.CommandText = "select * from jizhan where 基站名='aaa'"
oCmd.Connection.Close()
End Sub
问题:对sql server数据库进行查询后,查询结果如何输出到浏览器中?
查了一下资料,似乎要用datareaders对象,但不知具体用法,比如如下代码:
Dim myreader As SqldataReader=Nothing
myreader=myCommand.ExecuteReader()
While myreader.Read
szname=myreader("name").ToString
szemail=myReader("email").Tostring()
end while
不清楚上面代码的作用
如果将SQL server 查询的多条记录输出到浏览器,该如何操作?
感激不尽!
如以下代码:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oCmd As Data.SqlClient.SqlCommand
Dim strConn As String strConn &= "Data source=(local);"
strConn &= "initial catalog=gzgl;"
strConn &= "user id=sa;"
strConn &= "password=lifan;" oCmd = New Data.SqlClient.SqlCommand
oCmd.Connection = New Data.SqlClient.SqlConnection(strConn)
oCmd.Connection.Open()
oCmd.CommandText = "select * from jizhan where 基站名='aaa'"
oCmd.Connection.Close()
End Sub
问题:对sql server数据库进行查询后,查询结果如何输出到浏览器中?
查了一下资料,似乎要用datareaders对象,但不知具体用法,比如如下代码:
Dim myreader As SqldataReader=Nothing
myreader=myCommand.ExecuteReader()
While myreader.Read
szname=myreader("name").ToString
szemail=myReader("email").Tostring()
end while
不清楚上面代码的作用
如果将SQL server 查询的多条记录输出到浏览器,该如何操作?
感激不尽!
对于只读一条记录时,可以使用SqlDataReader对象。若多条,则不方便。
你可以使用一个数据控件,如DataList,GridView等。方便快捷。
将查询结果生成一个DataView,或者DataSet.
如:
SqlConnection conn=new SqlConnection("server=.;database=gzgl;uid=sa;pwd=lifan;");
conn.Open();
SqlCommand cmd=new SqlCommand("select * from jizhan where 基站名='aaa'",conn);
SqlDataAdepter sda=new SqlDataAdepter(cmd);
DataSet ds=new DataSet();
sda.Fill(ds,"ds");
GridView.DataSource=sda.tables["ds"].DefaultView;
GridView.DataBind();
使用数据源绑定数据控件,查询的数据记录就可以显示在浏览器了。
Dim oCmd As Data.SqlClient.SqlCommand
Dim strConn As String strConn = "Data source=.;"
strConn &= "initial catalog=Northwind;"
strConn &= "user id=sa;"
strConn &= "password=password" oCmd = New Data.SqlClient.SqlCommand
oCmd.Connection = New Data.SqlClient.SqlConnection(strConn)
oCmd.CommandText = "select * from Customers"
oCmd.Connection.Open() Dim myreader As Data.SqlClient.SqlDataReader = Nothing
myreader = oCmd.ExecuteReader()
While myreader.Read
Response.Write(myreader("CustomerID").ToString() & " " & myreader("CompanyName").ToString() & "<br>")
End While myreader.Close()
oCmd.Connection.Close()
End Sub
//aspx
<form id="form1" runat="server">
<div>
<asp:Button ID="Button1" runat="server" Text="Button" />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>//aspx.cs
Protected Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oCmd As Data.SqlClient.SqlCommand
Dim strConn As String strConn = "Data source=.;"
strConn &= "initial catalog=Northwind;"
strConn &= "user id=sa;"
strConn &= "password=password" oCmd = New Data.SqlClient.SqlCommand
oCmd.Connection = New Data.SqlClient.SqlConnection(strConn)
oCmd.CommandText = "select * from Customers"
oCmd.Connection.Open() Dim myreader As Data.SqlClient.SqlDataReader = Nothing
myreader = oCmd.ExecuteReader()
GridView1.DataSource = myreader
GridView1.DataBind()
myreader.Close()
oCmd.Connection.Close()
End Sub
这是我第一个asp.NET 程序,在兄弟的热心帮助下已经攻克了主要的难关。
感谢了!
还是看看MSDN,里面不少的示例哦
好。