实验报告六_ADONET中的数据绑定_.doc

实验目的：熟悉ADO.NET中的数据绑定，掌握使用GridView、DataList和FormView进行数据显示和处理的方法。实验条件： 电脑一台、能上网查阅资料。实验内容与步骤：（1） 实验内容：新建名字为“DataBinding_ Exercise”的网站。在网站中建立用于数据绑定的数据库。添加一个网页，利用GridVeiw实现数据的分页功能。 添加一个网页，利用DataList实现数据的分页功能。添加一个网页，利用FormView控件实现数据的插入、修改和删除操作，FormView界面及布局子定义。（2） 源代码：Student数据库：GridView.aspx:   GridView.aspx.cs:protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) bindgrid(); void bindgrid() string sqlconnstr = ConfigurationManager.ConnectionStringsconnectionstring.ConnectionString; DataSet ds = new DataSet(); using (SqlConnection sqlconn=new SqlConnection (sqlconnstr ) SqlDataAdapter sqld = new SqlDataAdapter(select no,name,birth,address from student,sqlconn ); sqld.Fill(ds,tabstudent); GridView1.DataSource = ds.Tablestabstudent.DefaultView; GridView1.DataBind(); protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) GridView1.PageIndex = e.NewPageIndex; bindgrid(); protected void GridView1_DataBound(object sender, EventArgs e) Label1.Text = 共 + (GridView1.PageCount).ToString() + 页; Label2.Text = 第 + (GridView1.PageIndex + 1).ToString() + 页; Label3.Text = string.Format(总页数：0，当前页 ：1,GridView1 .PageCount ,GridView1 .PageIndex +1);Datalist.aspx: asp:Label ID=Label2 runat=server Text= asp:Label ID=Label4 runat=server Text= asp:Label ID=Label6 runat=server Text= asp:Label ID=Label8 runat=server Text= 上一页  下一页 当前页： Datalist.aspx.cs:protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) Label9.Text = 1; listbind(); void listbind() int pag=Convert.ToInt32 (Label9 .Text ); string sqlconnstr = ConfigurationManager.ConnectionStringsconnectionstring.ConnectionString; DataSet ds = new DataSet(); using (SqlConnection sqlconn=new SqlConnection (sqlconnstr ) SqlDataAdapter sqld = new SqlDataAdapter(select * from student,sqlconn ); sqld.Fill(ds,tabstudent); PagedDataSource ps = new PagedDataSource(); ps.DataSource = ds.Tablestabstudent.DefaultView; ps.AllowPaging = true; ps.PageSize = 1; ps.CurrentPageIndex =pag; if (pag = 1) LinkButton1.Enabled = false; else LinkButton1.Enabled = true; if (pag = ps.PageCount) LinkButton2.Enabled = false; DataList1.DataSource = ps; DataList1.DataBind(); protected void LinkButton1_Click(object sender, EventArgs e) Label9.Text = Convert.ToString(Convert .ToInt32 (Label9 .Text )-1); listbind(); protected void LinkButton2_Click(object sender, EventArgs e) Label9.Text = Convert.ToString(Convert .ToInt32 (Label9 .Text )+1); listbind(); FormView.aspx: asp:TextBox ID=noTextBox runat=server Text = asp:TextBox ID=nameTextBox runat=server Text = asp:TextBox ID=birthTextBox runat=server Text = asp:TextBox ID=addressTextBox runat=server Text = 更新 取消 asp:TextBox ID=noTextBox runat=server Text = asp:TextBox ID=nameTextBox runat=server Text = asp:TextBox ID=birthTextBox runat=server Text = asp:TextBox ID=addressTextBox runat=server Text = 插入 取消 asp:Label ID=noLabel1 runat=server Text= asp:TextBox ID=nameTextBox runat=server Text = asp:TextBox ID=birthTextBox runat=server Text = asp:TextBox ID=addressTextBox runat=se