private string Gen_code() {
string rds = "";
using (MySqlConnection conn = new MySqlConnection("server = localhost;User Id=root;password=;database=teach"))
{
MySqlCommand cmd = new MySqlCommand("class_a", conn);
cmd.CommandType = CommandType.StoredProcedure;
MySqlParameter year = new MySqlParameter("c_year", MySqlDbType.Int16);
year.Direction = ParameterDirection.Input;
year.Value = 2015;
cmd.Parameters.Add(year);
conn.Open();
MySqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
rds= rd[0].ToString();
}
rd.Close();
}
return rds;
}