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);
}
}
这段代码的意思,功能说一下!!!!!!
{ 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);
}
}
这段代码的意思,功能说一下!!!!!!
{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);//加入参数
}
}
功能就是对参数操作吧
{if (conn.State != ConnectionState.Open)//判斷連接的狀態
conn.Open(); //如果conn沒打開,則Opencmd.Connection = conn;//声明命令对象(也就是server=''Database='',uid='',pwd='')
cmd.CommandText = cmdText; //命令语句(select * from table)if (trans != null)
cmd.Transaction = trans; //事务cmd.CommandType = cmdType; //命令类型(CommandType.StoredProcedure代表存储过程; CommandType.Text一般的SQL)if (cmdParms != null) //如果有参数
{
foreach (SqlParameter parm in cmdParms)
cmd.Parameters.Add(parm); //添加参数
}
}