打印本文 打印本文 关闭窗口 关闭窗口
VB.NET操作SQL Server完全模块
作者:武汉SEO闵涛  文章来源:敏韬网  点击数31993  更新时间:2007/11/14 12:20:54  文章录入:mintao  责任编辑:mintao
;       dataAdapter.Fill(dataSet)

            Return dataSet.Tables(0)

        Catch ex As Exception

            Throw New NotSupportedException(ex.Message)

        Finally

            sqlConnection.Close()

        End Try

    End Function

 

    Function GetDataTableBySQL(ByVal SuperSQL As String) As System.Data.DataTable

 

        Dim sqlConnection As New SqlClient.SqlConnection(GetConn)

 

        Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(SuperSQL, sqlConnection)

 

        Dim dataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter(sqlCommand)

        Dim dataSet As System.Data.DataSet = New System.Data.DataSet

        Try

            dataAdapter.Fill(dataSet)

            Return dataSet.Tables(0)

 << 上一页  [21] [22] [23] [24] [25] [26] [27] [28] [29]  下一页

打印本文 打印本文 关闭窗口 关闭窗口