1、拖放GridView2、在Page_Load中寫入下列代碼：（主要用來連接數(shù)GridViewSqlConnectionconn=protectedvoidPage_Load(objectsender,EventArgs｛conn=newSqlConnection("DataCatalog=bookshop;Integratedif{}}protectedvoid{Stringsql="select*fromSqlDataAdapterada=newSqlDataAdapter(sql,conn);DataSetdataSet=newDataSet();ada.Fill(dataSet,DataTabletable=dataSet.Tables["book"];GridView1.DataSource=table;}3、設(shè)置gridviewAutoGenerateColumnsFalse5、添加字段到GridViewprotectedvoidGridView1_PageIndexChanging(objectsender,GridViegeEventArgse){GridView1.PageIndex=e.NegeIndex;}8設(shè)計show.aspx頁面 并且添加DetailsView控件Page_Load(objectsender,EventArgse)寫下面的代碼：intid;protectedvoidPage_Load(objectsender,EventArgs{id=Convert.ToInt32(Request.QueryString["Id"]);SqlConnectionconn=newSqlConnection("DataSource=.;InitialCatalog=bookshop;IntegratedSecurity=True");Stringsql="select*frombookswhereSqlDataAdapterada=newSqlDataAdapter(sql,conn);DataSetdataSet=newDataSet();ada.Fill(dataSet,DataTabletable=DetailsView1.DataSource=table;}以上做完后會添加如下 teField<ItemTem<asp:LabelID="Label2"runat="server"Text="<%#bind('id')%>"></asp:Label></ItemTemte></asp:TemprotectedvoidGridView1_RowEditing(objectsender,GridViewEditEventArgse){GridView1.EditIndex=e.NewEditIndex;}protectedvoidGridView1_RowUpdating(objectsender,GridViewUpdateEventArgse){inteditIndex=GridView1.EditIndex;intid=doubleprice=Stringsql="updatebookssetUnitPrice="+price+"whereid="+id;mandcmd= mand(sql,{}

catch(Exception{}this.GridView2.EditIndex=-1;}protectedvoidGridView1_RowCancelingEdit(objectsender,GridViewCancelEditEventArgse){GridView2.EditIndex=-1;}}protectedvoidGridView1_RowDeleting(objectsender,GridViewDeleteEventArgse){intid=Stringsql="deletefrombookswhereId="+id;