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

            Throw New NotSupportedException(ex.Message)

        Finally

            sqlConnection.Close()

        End Try

 

        Return rowsAffected

    End Function

 

    Function GetFieldCount(ByVal TableName As String, ByVal ParaSQL As String) As Integer

 

        Dim sqlConnection As New SqlClient.SqlConnection(GetConn)

 

        Dim queryString As String = "SELECT COUNT(*) AS FieldCount FROM " & TableName & " where " & ParaSQL

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

 

        Dim rowsAffected As Integer

        sqlConnection.Open()

        Try

            rowsAffected = sqlCommand.ExecuteScalar

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

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