vb.net 如何调用存储过程，并绑定到DataGridView显示数据

[dgqqdgqq]

CREATE PROCEDURE [DBO].[Q_SysOperationTree]

@ED int

AS
SET NOCOUNT ON

Select ED,
PED,
NodeName
From SysOperationTree
Where ED LIKE ISNULL( @ED, '%' )
GO

如何把上面的存储过程，查询的数据绑定到DataGridView中显示，请教语句如何写。

[云中客]

Private Function SqlProc2(ByVal ProcName As String, ByVal Param1 As String) As DataSet
'定义命令对象，并使用储存过程
Dim myCommand As New SqlClient.SqlCommand
myCommand.CommandType = CommandType.StoredProcedure
myCommand.CommandText = "Q_SysOperationTree"
myCommand.Connection = myConn
'定义一个数据适配器，并设置参数
Dim myDapter As New SqlClient.SqlDataAdapter(myCommand)
myDapter.SelectCommand.Parameters.Add("@name", SqlDbType.int).Value = Param1
'定义一个数据集对象，并填充数据集
Dim myDataSet As New DataSet
Try
myDapter.Fill(myDataSet)
Catch ex As Exception
End Try
Return myDataSet
End Function

[云中客]

利用函数返回一个记录集,然后将数据绑定到DataGridView中

[skskaas]

mark