public DataSet SelectByUserno(String userno)
{
string cmdText = "select * from grade where userno = ?userno";
MySqlParameter param = new MySqlParameter("?userno", MySqlDbType.String);
param.Value = userno;
return(MysqlHelper.GetDataSet(cmdType, cmdText, param));
}
public DataSet SelectByPaperid(int paperid)
{
string cmdText = "select * from testpaperitem where paperid = ?paperid";
MySqlParameter param = new MySqlParameter("?paperid", MySqlDbType.Int32);
param.Value = paperid;
return(MysqlHelper.GetDataSet(cmdType, cmdText, param));
}
public DataSet SelectAll()
{
string cmdText = "select * from grade";
return(MysqlHelper.GetDataSet(cmdType, cmdText, null));
}
