public static int iDataType = 2;
public DataTable UserLogin(M_User mUr)
{
D_User dUr = new D_User();
StringBuilder sCmdText = new StringBuilder();
sCmdText.Append("Select * From User ");
sCmdText.Append("Where ");
sCmdText.Append("USER_ID = ");
sCmdText.Append("@USER_ID");
sCmdText.Append(" And ");
sCmdText.Append("PassWord = ");
sCmdText.Append("@PassWord");
//GetType(iDataType) ssp;
SqlParameter[] sSp = {
new SqlParameter("@USER_ID",SqlDbType.VarChar ,20),
new SqlParameter("@PassWord",SqlDbType.VarChar,50)
};
sSp[0].Value = mUr.User_ID;
sSp[1].Value = mUr.PassWord;
return dUr.GetSqlDataTable(sCmdText.ToString(), sSp);
//return.dUr.GetMySqlDataTable(sCmdText.ToString(), sSp);
}
我现在想换成MYSQL数据库
只想改一个参数就能实现iDataType
SqlParameter与MySqlParameter不能通用,请问如何解决
public DataTable UserLogin(M_User mUr)
{
D_User dUr = new D_User();
StringBuilder sCmdText = new StringBuilder();
sCmdText.Append("Select * From User ");
sCmdText.Append("Where ");
sCmdText.Append("USER_ID = ");
sCmdText.Append("@USER_ID");
sCmdText.Append(" And ");
sCmdText.Append("PassWord = ");
sCmdText.Append("@PassWord");
//GetType(iDataType) ssp;
SqlParameter[] sSp = {
new SqlParameter("@USER_ID",SqlDbType.VarChar ,20),
new SqlParameter("@PassWord",SqlDbType.VarChar,50)
};
sSp[0].Value = mUr.User_ID;
sSp[1].Value = mUr.PassWord;
return dUr.GetSqlDataTable(sCmdText.ToString(), sSp);
//return.dUr.GetMySqlDataTable(sCmdText.ToString(), sSp);
}
我现在想换成MYSQL数据库
只想改一个参数就能实现iDataType
SqlParameter与MySqlParameter不能通用,请问如何解决
DbParameter不能通用MySqlParameter