冠霖的部落格

c# 版本

 ///

    ///為執行命令準備參數

    ////>

    private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType,string cmdText,SqlParameter[] cmdParms)

    {

        //判斷數據庫的連接狀態

        if (conn.State != ConnectionState.Open)

            conn.Open();

        cmd.Connection = conn;

        cmd.CommandText = cmdText;

        //判斷是否需要事物處理

        if (trans != null)

            cmd.Transaction = trans;

        cmd.CommandType = cmdType;

        if (cmdParms != null)

        {

            foreach (SqlParameter parm in cmdParms)

            {

                cmd.Parameters.Add(parm);

            }

        }

    }

vb版本

 Private Shared Sub PrepareCommand(ByVal cmd As SqlCommand, ByVal conn As SqlConnection, ByVal trans As SqlTransaction, ByVal cmdText As String, ByVal cmdParms() As SqlParameter)
        If conn.State <> ConnectionState.Open Then
            conn.Open()
        End If
        cmd.Connection = conn
        cmd.CommandText = cmdText
        If Not trans Is Nothing Then
            cmd.Transaction = trans
        End If
        cmd.CommandType = CommandType.Text 'cmdType;
        If Not cmdParms Is Nothing Then

            Dim parameter As SqlParameter
            For Each parameter In cmdParms
                    If (parameter.Direction = ParameterDirection.InputOutput Or parameter.Direction = ParameterDirection.Input ) Then
                    parameter.Value = DBNull.Value
                End If
                cmd.Parameters.Add(parameter)
            Next
        End If
    End Sub