书籍电子商务网站.pptVIP

An Introduction to Database Systenm 九、书籍管理网页 bookManage.aspx 检索相关书籍 修改和删除 主要控件： Gridview ObjectDataSource 界面部分重点内容介绍： Gridview1 asp:GridView ID=GridView1 runat=server AllowPaging=True AllowSorting=True DataSourceID=ObjectDataSource_Search DataKeyNames=BookID PageSize=2 AutoGenerateColumns=False OnDataBound=GridView_DataBound Columns asp:CommandField ShowDeleteButton=True“ ShowEditButton=True / asp:BoundField DataField=BookName HeaderText=书名 / asp:BoundField DataField=Author HeaderText=作者 / asp:BoundField DataField=MarketPrice HeaderText=市场价 / asp:BoundField DataField=HotPrice HeaderText=热销价 SortExpression=HotPrice / /Columns asp:ObjectDataSource ID=ObjectDataSource_Search runat=server“ EnablePaging=True SelectCountMethod=GetBookCountByDetail SelectMethod=ListOnePageSortedBookByDetail TypeName=BookTask SortParameterName=SortColumnExpression DeleteMethod=BookDelete UpdateMethod=BookUpdate 界面部分重点内容介绍： ObjectDataSource UpdateParameters asp:Parameter Name=BookName Type=string / asp:Parameter Name=Author Type=string / asp:Parameter Name=MarketPrice Type=string / asp:Parameter Name=HotPrice Type=string / /UpdateParameters DeleteParameters asp:Parameter Name=BookID Type=Int32 / /DeleteParameters //删除书刊记录 public void BookDelete(int BookID) { SqlConnection con = ConnectionFactory.CreateConnection(); SqlCommand cmd = new SqlCommand(delete from tb_BookInfo where BookID=@BookID,con); cmd.Parameters.AddWithValue(@BookID, BookID); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } BookTask业务类的删除书籍记录方法： BookTask业务类的修改书籍记录方法：BookUpdate //修改书籍记录 public void BookUpdate(int BookID, string BookName, string Author, float