写student类中的select，delete，update，insert方法并在objectDataSource中应用（分别写两个，一个返回datatable，一个使用list）_7.参照insert方法,在publishcontroller类中,分别写出select,updat-优快云博客

本文链接：https://blog.youkuaiyun.com/liu_111111/article/details/8262729

本文介绍了一个使用ASP.NET中ObjectDataSource控件进行数据绑定的例子。该示例展示了如何通过ObjectDataSource实现对Students类的数据增删改查操作，并在GridView中展示数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

objectDataSource前台代码:

<body>
<form id="form1" runat="server">
<div>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
DeleteMethod="SudentDelete"
SelectMethod="GetStudent" TypeName="_12_4.Students"
UpdateMethod="SudentUpdate">
<DeleteParameters>
<asp:Parameter Name="Fid" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="fid" Type="Int32" />
<asp:Parameter Name="FName" Type="String" />
<asp:Parameter Name="FAge" Type="Int32" />
<asp:Parameter Name="FGender" Type="Boolean" />
<asp:Parameter Name="FMath" Type="Int32" />
<asp:Parameter Name="FEnglish" Type="Int32" />
</UpdateParameters>
</asp:ObjectDataSource>

<br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" CellPadding="4" DataSourceID="ObjectDataSource1"
ForeColor="#333333" GridLines="None" AutoGenerateColumns="False"
DataKeyNames="Fid">
<AlternatingRowStyle BackColor="White" />
<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="FAge" HeaderText="FAge" SortExpression="FAge" />
<asp:CheckBoxField DataField="FGender" HeaderText="FGender"
SortExpression="FGender" />
<asp:BoundField DataField="FMath" HeaderText="FMath" SortExpression="FMath" />
<asp:BoundField DataField="FEnglish" HeaderText="FEnglish"
SortExpression="FEnglish" />
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>

</div>

Students类:

public class Students
{

public int Fid { get; set; }
public string FName { get; set; }
public int FAge { get; set; }
public bool FGender { get; set; }
public Double FMath { get; set; }
public Double FEnglish { get; set; }

public DataTable StudentSelect()
{
string sql = "select * from Students";
return SqlHelp.ExectuDataTable(sql);
}

public void SudentDelete(int Fid)
{
string sql = "delete from Students where Fid=@id";
SqlParameter pms = new SqlParameter("@id",Fid);
SqlHelp.ExectuNonQuery(sql, pms);
}

public void SudentUpdate(int Fid, string FName, int FAge, bool FGender, int FMath, int FEnglish)
{
string sql = "update Students set FName=@n,FAge=@a,FGender=@g,FMath=@m,FEnglish=@e where Fid=@id";
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("id", Fid),new SqlParameter("n", FName), new SqlParameter("a", FAge),
new SqlParameter("g",FGender),new SqlParameter("m",FMath),new SqlParameter("e",FEnglish)
};

SqlHelp.ExectuNonQuery(sql, pms);
}

public int StudentInsert(string FName, int FAge, bool FGender, int FMath, int FEnglish)
{
string sql = "insert into Students values (@n,@a,@g,@m,@e)";
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("n", FName), new SqlParameter("a", FAge),
new SqlParameter("g",FGender),new SqlParameter("m",FMath),new SqlParameter("e",FEnglish)
};

return SqlHelp.ExectuNonQuery(sql, pms);
}

public List<Students> GetStudent()
{
string sql = "select * from Students";
DataTable dt=SqlHelp.ExectuDataTable(sql);
List<Students> list=new List<Students>();
foreach (DataRow row in dt.Rows)
{
Students stu=new Students();
stu.Fid=(int) row[0];
stu.FName = row[1].ToString();
stu.FAge = (int)row[2];
stu.FGender = (bool)row[3];
stu.FMath = (Double)row[4];
stu.FEnglish = (Double)row[5];
list.Add(stu);
}
return list;
}

}