StudentDAL
public class StudentDAL
{
public List<Grade> SelectGradeName()
{
string str = SqlHelper.Constr;
string sql = "select * from grade";
List<Grade> glist = new List<Grade>();
using (SqlConnection con = new SqlConnection(str))
{
SqlCommand cmd = new SqlCommand(sql,con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Grade item = new Grade();
item.GradeId = Convert.ToInt32(dr["gradeid"]);
item.GradeName = dr["gradename"].ToString();
glist.Add(item);
}
dr.Close();
return glist;
}
}
public List<Subje