<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);
}
}