定义sql参数,用于sqlhelper,以下写法,定义和赋值要分开 ,麻烦!
SqlParameter[] arParms = {
new SqlParameter("@username", SqlDbType.VarChar, 32),
new SqlParameter("@password", SqlDbType.VarChar, 32)
}; arParms[0].Value = username;
arParms[1].Value = password;
有没简便的写法,定义和赋值一行搞定,类似:
da.SelectCommand.Parameters.Add("@intPageSize", SqlDbType.Int).Value = pageSize; SqlParameter[] arParms 并没有add方法哦
SqlParameter[] arParms = {
new SqlParameter("@username", SqlDbType.VarChar, 32),
new SqlParameter("@password", SqlDbType.VarChar, 32)
}; arParms[0].Value = username;
arParms[1].Value = password;
有没简便的写法,定义和赋值一行搞定,类似:
da.SelectCommand.Parameters.Add("@intPageSize", SqlDbType.Int).Value = pageSize; SqlParameter[] arParms 并没有add方法哦
public static OleDbParameter MakeInParam(string ParamName, OleDbType colType, int Size, object value)
{
OleDbParameter param = new OleDbParameter(ParamName, colType, Size);
param.Value = value;
return param;
}然后:
DbParameter[] param ={
DbHelper.MakeInParam("@userName",OleDbType.VarWChar,100,info.UserName),
DbHelper.MakeInParam("@userPwd",OleDbType.VarWChar,100,info.UserPwd), DbHelper.MakeInParam("@userRole",OleDbType.Integer,4,info.UserRole),
};
AddValue()这个方法吧好像
new SqlParameter("@username", username),
new SqlParameter("@password",password)
};
--
就这样就可以了