写student类中的select，delete，update，insert方法并在objectDataSource中应用（分别写两个，一个返回datatable，一个使用list）

select datatable:
public DataTable StudentSelect()
        {
            string sql = "select sid,sname,sex,age,photo from student";
            return SqlHelper.ExecuteDataTable(sql);

        }
list:
        public int SID { get; set; }
        public string SNAME { get; set; }
        public string SEX { get; set; }
        public int AGE { get; set; }
        public string PHOTO { get; set; }

    public List<Student> GetStudents()
        {
            string sql = "select sid,sname,sex,age,photo from student";
            DataTable dt = SqlHelper.ExecuteDataTable(sql);
            List<Student> list = new List<Student>();
            foreach (DataRow row in dt.Rows)
            {
                Student stu=new Student();
                stu.SID=(int)row[0];
                stu.SNAME=row[1].ToString();
                stu.SEX=row[2].ToString();
                stu.AGE=Convert.ToInt32(row[3]);
                stu.PHOTO=row[4].ToString();
                list.Add(stu);
            }

            return list;
        }
delete  datatable:

public int StudentDelete(int sid)
        {
            string sql = "delete from student where sid=@sid";
            SqlParameter pms = new SqlParameter("@sid", sid);

            return SqlHelper.ExecuteNoQuery(sql, pms);
        }

updata datatable:

 public int StudentUpdate(int sid,string sname,string sex,int age,string photo)
        {
            string sql = "update student set sname=@sname,sex=@sex,age=@age,photo=@photo where sid=@sid";

            SqlParameter[] pms = new SqlParameter[]
            {
            new SqlParameter("@sname",sname),
            new SqlParameter("@sex",sex),
            new SqlParameter("@age",age),
            new SqlParameter("@photo",photo),
            new SqlParameter("@sid",sid)
            };

            return SqlHelper.ExecuteNoQuery(sql, pms);
        }

insert datatable:

 public int StudentInsert( string sname, string sex, int age, string photo)
        {
            string sql = "insert into student(sname,sex,age,photo) values(@sname,@sex,@age,@photo)";
            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@sname",sname),
            new SqlParameter("@sex",sex),
            new SqlParameter("@age",age),
            new SqlParameter("@photo",photo)
            };
            return SqlHelper.ExecuteNoQuery(sql, pms);
        }