打印本文 打印本文 关闭窗口 关闭窗口
VB.NET操作SQL Server完全模块
作者:武汉SEO闵涛  文章来源:敏韬网  点击数31976  更新时间:2007/11/14 12:20:54  文章录入:mintao  责任编辑:mintao
        Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)

 

        Dim rowsAffected As Integer = 0

        sqlConnection.Open()

        Try

            rowsAffected = sqlCommand.ExecuteNonQuery

        Catch ex As Exception

            Throw New NotSupportedException(ex.Message)

        Finally

            sqlConnection.Close()

        End Try

 

        Return rowsAffected

    End Function

    Function DelBySQL(ByVal StrSQL As String) As Integer

 

        Dim sqlConnection As New SqlClient.SqlConnection(GetConn)

 

        Dim queryString As String = StrSQL

        Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Dat

 << 上一页  [11] [12] [13] [14] [15] [16] [17] [18] [19] [20]  ...  下一页 >> 

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