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

<body>
    <form id="form1" runat="server">
    <div>
   
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
            SelectMethod="GetStudent" TypeName="_12_3调用.objectfsfs.student"
            DeleteMethod="DeleteStudent" UpdateMethod="UpDateStudent"
            DataObjectTypeName="_12_3调用.objectfsfs.student"
            InsertMethod="InsertStudent">
        </asp:ObjectDataSource>
        <br />
        <asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1"
            AllowPaging="True" AllowSorting="True" CellPadding="4" ForeColor="#333333"
            GridLines="None" AutoGenerateColumns="False" DataKeyNames="FID">
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
                    ShowSelectButton="True" />
                <asp:BoundField DataField="FID" HeaderText="FID" SortExpression="FID" />
                <asp:BoundField DataField="FNAME" HeaderText="FNAME" SortExpression="FNAME" />
                <asp:BoundField DataField="FGENDER" HeaderText="FGENDER"
                    SortExpression="FGENDER" />
                <asp:BoundField DataField="FAGE" HeaderText="FAGE" SortExpression="FAGE" />
            </Columns>
            <EditRowStyle BackColor="#999999" />
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#E9E7E2" />
            <SortedAscendingHeaderStyle BackColor="#506C8C" />
            <SortedDescendingCellStyle BackColor="#FFFDF8" />
            <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
        </asp:GridView>
    
    </div>
    </form>
</body>

 

 

 

 

 

类中的应用

 

 

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
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值