mysql - 获取sql后检索DataRow

Question

我是 VB.net 新手，我需要创建通用函数来检索数据行。我尝试了这个方法。但这并不成功。

Function GetRecord(ByVal sql As String) As DataRow
        Dim conn As MySqlConnection = connect()
        Dim objDataSet As New DataSet
        Dim dt As DataTable
        Dim dr As DataRow
        Try
            Dim cmd As New MySqlCommand()
            conn.Open()
            cmd.Connection = conn
            cmd.CommandText = sql
            Dim da As New MySqlDataAdapter
            da.SelectCommand = cmd
            Dim ds As New DataSet
            da.Fill(ds, "T")
            dt = ds.Tables("T")
            dr = dt.Rows.Item(0)
        Catch e As Exception
            Throw e
        Finally
            conn.Close()
        End Try
        GetRecord = dr
    End Function

备注:Connect()函数返回mysql连接对象

Answer 1

不太确定您要做什么，但将代码更改为类似

    da.Fill(dt, "T")
    Catch e As Exception
        Throw e
    Finally
        conn.Close()
    End Try
    GetRecord = dt.Rows.Item(0)