写一个类的方法并在objectDataSource中应用

最新推荐文章于 2017-07-09 15:04:00 发布

耿宇丹

最新推荐文章于 2017-07-09 15:04:00 发布

阅读量490

点赞数

分类专栏： ASP.NET高级

本文链接：https://blog.csdn.net/gengyudan/article/details/8257488

版权

ASP.NET高级专栏收录该内容

19 篇文章 0 订阅

订阅专栏

类中的应用

namespace _12_3调用.objectfsfs
{
    public class student
    {
        //适用于方法2：
        public int FID{get;set;}
        public string FNAME { get; set; }
        public string FGENDER { get; set; }
        public int FAGE { get; set; }

        //方法1：select
        public DataTable StudentSelect()
        {
            string sql = "select * from Mystudent2";
            return _11_28DataSet111.SqlHealper1.ExecuteDataTable(sql);
        }
        //方法1：Delete
        public int StudentDelete(int FId)
        {
            string sql = "delete from Mystudent2 where FId=@fid";
            SqlParameter pms=new SqlParameter("@fid",FId);
            return _11_28DataSet111.SqlHealper1.ExecuteNonQuery(sql, pms);
        }

        //方法1：UpDate
        public int StudentUpDate(int FId,string FName,int FAge,string FGender)
        {
            string sql = "update Mystudent2 set FName=@fname,FAge=@fage,FGender=@fgender where FId=@fid";
            SqlParameter[] pmss = new SqlParameter[]
            {
            new SqlParameter("@fname", FName),
            new SqlParameter("@fage", FAge),
            new SqlParameter("@fgender", FGender),
            new SqlParameter("@fid", FId)
        };
            return _11_28DataSet111.SqlHealper1.ExecuteNonQuery(sql,pmss);
        }

        //方法2：list<>方法，select
        public List<student> GetStudent()
        {
        string sql="select * from Mystudent2";
        DataTable dt= _11_28DataSet111.SqlHealper1.ExecuteDataTable(sql);
        List<student> list = new List<student>();
            foreach(DataRow row in dt.Rows)
            {
                student stu = new student();
                stu.FID = (int)row[0];
                stu.FNAME = row[1].ToString();
                stu.FAGE = Convert.ToInt32(row[2]);
                stu.FGENDER = row[3].ToString();

                list.Add(stu);
            }
            return list;
        }

        //方法2:2、update的内容
        public void UpDateStudent(student s)
        {
            string sql = "update Mystudent2 set FName=@fname,FAge=@fage,FGender=@fgender where FId=@fid";
            SqlParameter[] pmss = new SqlParameter[]
            {
            new SqlParameter("@fname", s.FNAME),
            new SqlParameter("@fage", s.FAGE),
            new SqlParameter("@fgender", s.FGENDER),
            new SqlParameter("@fid", s.FID)
        };
             _11_28DataSet111.SqlHealper1.ExecuteNonQuery(sql, pmss);
        }

        //方法2：delete的内容
        public void DeleteStudent(student f)
        {
            string sql = "delete from Mystudent2 where FId=@fid";
            SqlParameter pms = new SqlParameter("@fid",f.FID);
             _11_28DataSet111.SqlHealper1.ExecuteNonQuery(sql, pms);
        }

}

耿宇丹

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
写一个类的方法并在objectDataSource中应用

SelectMethod="GetStudent" TypeName="_12_3调用.objectfsfs.student" DeleteMethod="DeleteStudent" UpdateMethod="UpDateStudent" DataObjectTypeName="_12_3调用.objectfsfs.student"
复制链接

扫一扫

专栏目录