ASP.Net课堂--实验5

1、 新建一个网站，在网站中新建一个”images”文件夹，将FTP中的a.jpg和e.jpg拷贝到images文件夹中。

2、 新建test数据库，在test数据库中新建book_info表，结构如下：

当用户单击“详细信息”时（在超链接中显示“详细信息”不需设置HyperLinkField的“DataTextField”属性，只需设置”Text”属性的值为”详细信息”就行），导航到detail.aspx页面，在detail.aspx中显示该条记录的详细信息。

4、 在GridView.aspx页面中，通过在GridView控件中手动添加代码来在控件中添加一个文本框：

               runat="server"Text='<%#Eval("book_id") %>'>

  此段代码放置在和里，作用通过建立一个模版，在GridView控件中添加一列，此列中包含一个文本框，将文本框中绑定到book_id列。

5、 参照PPT中的内容，添加gridview3.aspx页面，在此页面中只添加一个GridView控件。通过编程来实现在GridView中编辑数据。

A、首先通过编程将book_info表中的数据通过GridView显示；

B、再在GridView中添加“编辑”按钮:在”源“视图中在中添加代码：

C、编辑GridView控件的RowEditing、RowUpdating、RowCancelingEdit事件。

   注：e.RowIndex  为被编辑行在GridView中的行号（从0开始）

      GridView1.Rows[e.RowIndex].  为GridView中被编辑的行。

       GridView1.Rows[e.RowIndex].Cells[1].   为GridView中被编辑的行的第2列。

      GridView1.Rows[e.RowIndex].Cells[1].Controls[0]为GridView中被编辑的行的第2列中的第一个控件。

GridView.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridView.aspx.cs" Inherits="GridView" %>







    


    
    

                    DataKeyNames="book_id" DataSourceID="SqlDataSource1" 
            EnableModelValidation="True">
            
                                    SortExpression="book_name" />
                                    SortExpression="author" />
                
                
                
                                    Text="详细信息" />
                
            
                           runat="server" Text='<%# Eval("book_id") %>'>
             
          






            
        
    

            COnnectionString="<%$ ConnectionStrings:testConnectionString %>" 
        SelectCommand="SELECT * FROM [book_info]">
    


 

gridview3.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridView3.aspx.cs" Inherits="GridView3" MaintainScrollPositiOnOnPostback="True" %>





    


    
    

    
                Onrowcancelingedit="GridView1_RowCancelingEdit" 
            Onrowediting="GridView1_RowEditing" Onrowupdating="GridView1_RowUpdating" 
            >
        
            
        
        
    
    

    

  gridview3.aspx.cx

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

public partial class GridView3 : System.Web.UI.Page
{
    //创建连接对象
    public SqlConnection cOnn= new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            myBind();
        }  
    }


    /// 

    /// GridViews数据绑定
    /// 

    public void myBind()
    {
        string sqlStr = "select * from book_info";
        SqlDataAdapter myDataAdapter = new SqlDataAdapter(sqlStr, conn);
        DataSet myDataSet = new DataSet();
        myDataAdapter.Fill(myDataSet, "book_info");
        GridView1.DataSource = myDataSet;
        GridView1.DataBind();
    }

    //编辑
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        //设计编辑行的索引
        GridView1.EditIndex = e.NewEditIndex;
        myBind();
    }
    //更新
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string book_id = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString();
        string book_name = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString();
        string author = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString();
        string press = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString();
        string price = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString();
        string image_path = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString();

        string sqlStr = "update book_info set book_name=@book_name,author=@author,press=@press,price=@price,image_path=@image_path where book_id=@book_id";
        SqlParameter[] parameters = {new SqlParameter("@book_id", Convert.ToInt32(book_id)),
                                    new SqlParameter("@book_name",book_name), 
                                    new SqlParameter("@author", author),
                                    new SqlParameter("@press",press),
                                    new SqlParameter("@price",Convert.ToInt32(price)),
                                    new SqlParameter("@image_path", image_path)};


        string sql = ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString;
        using (SqlConnection cOnn= new SqlConnection(sql))
        {
            conn.Open();
            using (SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = sqlStr;
                cmd.Parameters.AddRange(parameters);
                cmd.ExecuteNonQuery();
            }
        }
        GridView1.EditIndex = -1;
        myBind();
    }
    //取消操作
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.ShowFooter = false;
        GridView1.EditIndex = -1;
        myBind();
    }
}