3? 使用ObjectDataSource完成上述题目 (添加select、delete、update和insert对应的类和方法)
<html xmlns="http://www.w3.org/1999/xhtml">
< head runat="server">
<title></title>
< /head>
< body>
<form id="form1" runat="server">
<div>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="StudentsSelect" TypeName="ASP绑定控件.Student"></asp:ObjectDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
DataSourceID="ObjectDataSource1">
</asp:GridView>
</div>
</form>
< /body>
< /html>
4? 实现页面中输入学生id,单机按钮后使该学生的年龄加。(尝试使用三层—选作)
UI层
前台部分
<html xmlns="http://www.w3.org/1999/xhtml">
< head runat="server">
<title></title>
< /head>
< body>
<form id="form1" runat="server">
<div>
请输入学生的Id:<asp:TextBox ID="txtid" runat="server"></asp:TextBox>
<br />
<asp:Button ID="Button1" runat="server" Xοnclick="Button1_Click" Text="该学生的年龄加1"
Width="263px" />
</div>
</form>
< /body>
< /html>
后台部分
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ASP绑定控件.Bll;
namespace ASP绑定控件.UI
{
public partial class ui1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
int fid = Convert.ToInt32(txtid.Text.Trim());
MyStudentsBll bll = new MyStudentsBll();
bool b= bll.AgeAddById(fid);
if (b == true)
{
Response.Write("修改成功!");
}
else
{
Response.Write("修改失败!");
}
}
}
}
DAL层
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
namespace ASP绑定控件.DAL
{
/// <summary>
///
/// </summary>
public class MyStudentsDal
{
public int AgeAddById(int Fid)
{
string sql = "update MyStudents set FAge=FAge+1 where FId=@id";
SqlParameter pms = new SqlParameter("@id", Fid);
return sqlHealpler.sqlHealper.ExecturNonQuery(sql, pms);
}
}
}
Bll层
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using ASP绑定控件.DAL;
namespace ASP绑定控件.Bll
{
public class MyStudentsBll
{
public bool AgeAddById(int fid)
{
MyStudentsDal dal = new MyStudentsDal();
int r= dal.AgeAddById(fid);
if (r > 0)
{
return true;
}
else
{
return false;
}
}
}
}
<html xmlns="http://www.w3.org/1999/xhtml">
< head runat="server">
<title></title>
< /head>
< body>
<form id="form1" runat="server">
<div>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="StudentsSelect" TypeName="ASP绑定控件.Student"></asp:ObjectDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
DataSourceID="ObjectDataSource1">
</asp:GridView>
</div>
</form>
< /body>
< /html>
4? 实现页面中输入学生id,单机按钮后使该学生的年龄加。(尝试使用三层—选作)
UI层
前台部分
<html xmlns="http://www.w3.org/1999/xhtml">
< head runat="server">
<title></title>
< /head>
< body>
<form id="form1" runat="server">
<div>
请输入学生的Id:<asp:TextBox ID="txtid" runat="server"></asp:TextBox>
<br />
<asp:Button ID="Button1" runat="server" Xοnclick="Button1_Click" Text="该学生的年龄加1"
Width="263px" />
</div>
</form>
< /body>
< /html>
后台部分
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ASP绑定控件.Bll;
namespace ASP绑定控件.UI
{
public partial class ui1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
int fid = Convert.ToInt32(txtid.Text.Trim());
MyStudentsBll bll = new MyStudentsBll();
bool b= bll.AgeAddById(fid);
if (b == true)
{
Response.Write("修改成功!");
}
else
{
Response.Write("修改失败!");
}
}
}
}
DAL层
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
namespace ASP绑定控件.DAL
{
/// <summary>
///
/// </summary>
public class MyStudentsDal
{
public int AgeAddById(int Fid)
{
string sql = "update MyStudents set FAge=FAge+1 where FId=@id";
SqlParameter pms = new SqlParameter("@id", Fid);
return sqlHealpler.sqlHealper.ExecturNonQuery(sql, pms);
}
}
}
Bll层
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using ASP绑定控件.DAL;
namespace ASP绑定控件.Bll
{
public class MyStudentsBll
{
public bool AgeAddById(int fid)
{
MyStudentsDal dal = new MyStudentsDal();
int r= dal.AgeAddById(fid);
if (r > 0)
{
return true;
}
else
{
return false;
}
}
}
}