读书人

!listview控件接收存储过程返回的多行

发布时间: 2012-07-31 12:33:46 作者: rapoo

求助!listview控件接收存储过程返回的多行数据集

VB.NET code
Private Sub TreeView1_NodeMouseClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeNodeMouseClickEventArgs) Handles TreeView1.NodeMouseClick        '下面是点击节点触发的事件        Select Case e.Node.Tag            Case "yggl"                ListView_yuangong.Visible = True                Dim ygglSQL = New SqlClient.SqlCommand("list_user", dbConnection)                ygglSQL.CommandType = CommandType.StoredProcedure                '???这里怎么定义接收返回的数据集??                dbConnection.open()                ygglSQL.ExecuteReader()                '????这里怎么接收返回的数据集,让它显示到ListView_yuangong控件                dbConnection.close()            Case ("zy")                ListView_yuangong.Visible = False        End Select    End Sub


[解决办法]
我只是给你的思路,你竟然直接往里面贴,无语了。。。
应该用OleDbDataReader

下面是一个完整的微软的例子,来自 http://msdn.microsoft.com/en-us/library/haa3afyz(v=vs.71).aspx

VB.NET code
Dim nwindConn As OleDbConnection = New OleDbConnection("Provider=MSDataShape;Data Provider=SQLOLEDB;" & _                                         "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind")Dim custCMD As OleDbCommand = New OleDbCommand("SHAPE {SELECT CustomerID, CompanyName FROM Customers} " & _                                         "  APPEND ({SELECT CustomerID, OrderID FROM Orders} AS CustomerOrders " & _                                         "  RELATE CustomerID TO CustomerID)", nwindConn)nwindConn.Open()Dim custReader As OleDbDataReader = custCMD.ExecuteReader()Dim orderReader As OleDbDataReaderDo While custReader.Read()  Console.WriteLine("Orders for " & custReader.GetString(1)) ' custReader.GetString(1) = CompanyName  orderReader = custReader.GetValue(2)                       ' custReader.GetValue(2) = Orders chapter as DataReader  Do While orderReader.Read()    Console.WriteLine(vbTab & orderReader.GetInt32(1))       ' orderReader.GetInt32(1) = OrderID  Loop  orderReader.Close()LoopcustReader.Close()nwindConn.Close() 

读书人网 >VB Dotnet

热点推荐