3• 使用ObjectDataSource完成上述题目（添加select、delete、update和insert对应的类和方法）

来源：互联网发布：xp设置网络打印机共享编辑：程序博客网时间：2024/06/03 13:31

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" Xonclick="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;
   }
}
}
}

3• 使用ObjectDataSource完成上述题目 （添加select、delete、update和insert对应的类和方法）

3• 使用ObjectDataSource完成上述题目（添加select、delete、update和insert对应的类和方法）