【正文】 able tr td style=width: 100px。 height: 23px asp:DropDownList ID=DropDownList1 runat=server DataSourceID=SqlDataSource2 DataTextField=xnd DataValueField=xnd /asp:DropDownListasp:SqlDataSource ID=SqlDataSource2 runat=server ConnectionString=%$ ConnectionStrings:bmConnectionString % SelectCommand=SELECT DISTINCT [xnd] FROM [dingshu]/asp:SqlDataSource /td td style=width: 100px。 height: 23px asp:DropDownList ID=DropDownList2 runat=server DataSourceID=SqlDataSource3 DataTextField=bookname DataValueField=bookname /asp:DropDownListasp:SqlDataSource ID=SqlDataSource3 runat=server ConnectionString=%$ ConnectionStrings:bmConnectionString % SelectCommand=SELECT DISTINCT [bookname] FROM [dingshu]/asp:SqlDataSource /td td style=width: 100px。 height: 23px asp:Button ID=Button1 runat=server Text=統(tǒng)計 OnClick=Button1_Click //td /tr tr td style=width: 100px asp:DropDownList ID=DropDownList3 runat=server DataSourceID=SqlDataSource2 DataTextField=xnd DataValueField=xnd /asp:DropDownList/td td style=width: 100px asp:DropDownList ID=DropDownList4 runat=server DataSourceID=SqlDataSource4 DataTextField=department DataValueField=department /asp:DropDownListasp:SqlDataSource ID=SqlDataSource4 runat=server ConnectionString=%$ ConnectionStrings:bmConnectionString % SelectCommand=SELECT DISTINCT [department] FROM [dingshu] WHERE ([department] IS NOT NULL) /asp:SqlDataSource /td td style=width: 100px asp:Button ID=Button2 runat=server Text=統(tǒng)計 OnClick=Button2_Click //td /tr tr td align=center colspan=3 asp:GridView ID=GridView1 runat=server AutoGenerateColumns=False DataSourceID=SqlDataSource1 PageSize=5 AllowPaging=True CellPadding=4 FontSize=Small ForeColor=333333 GridLines=None Columns asp:BoundField DataField=ds_ID HeaderText=訂書ID InsertVisible=False ReadOnly=True SortExpression=ds_ID / asp:BoundField DataField=bookname HeaderText=書名 SortExpression=bookname / asp:BoundField DataField=xnd HeaderText=學(xué)年度 SortExpression=xnd / asp:BoundField DataField=teacher HeaderText=教師 SortExpression=teacher / asp:BoundField DataField=department HeaderText=系 SortExpression=department / asp:BoundField DataField=class HeaderText=班級 SortExpression=class / asp:BoundField DataField=number HeaderText=數(shù)量 SortExpression=number / asp:CheckBoxField DataField=jiaocaike HeaderText=教材科 SortExpression=jiaocaike / asp:BoundField DataField=time HeaderText=訂書時間 SortExpression=time / /Columns FooterStyle BackColor=990000 FontBold=True ForeColor=White / RowStyle BackColor=FFFBD6 ForeColor=333333 / SelectedRowStyle BackColor=FFCC66 FontBold=True ForeColor=Navy / PagerStyle BackColor=FFCC66 ForeColor=333333 HorizontalAlign=Center / HeaderStyle BackColor=990000 FontBold=True ForeColor=White / AlternatingRowStyle BackColor=White / /asp:GridView asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString=%$ ConnectionStrings:bmConnectionString % SelectCommand=SELECT [ds_ID], [time], [bookname], [xnd], [jiaocaike], [teacher], [department], [class], [number] FROM [dingshu] WHERE (([xnd] = @xnd) AND ([bookname] = @bookname)) SelectParameters asp:ControlParameter ControlID=DropDownList1 Name=xnd PropertyName=SelectedValue Type=String / asp:ControlParameter ControlID=DropDownList2 Name=bookname PropertyName=SelectedValue Type=String / /SelectParameters /asp:SqlDataSource asp:GridView ID=GridView2 runat=server AutoGenerateColumns=False CellPadding=4 DataKeyNames=ds_ID DataSourceID=SqlDataSource5 FontSize=Small ForeColor=333333 GridLines=None AllowPaging=True PageSize=5 FooterStyle BackColor=990000 FontBold=True ForeColor=White / Columns asp:BoundField DataField=ds_ID HeaderText=訂書ID InsertVisible=False ReadOnly=True SortExpression=ds_ID / asp:BoundField DataField=bookname HeaderText=書名 SortExpression=bookname / asp:BoundField DataField=xnd HeaderText=學(xué)年度 SortExpression=xnd / asp:BoundField DataField=teacher HeaderText=教師 SortExpression=teacher / asp:BoundField DataField=department HeaderText=系 SortExpression=department / asp:BoundField DataField=class HeaderText=班級 SortExpression=class / asp:BoundField DataField=number HeaderText=數(shù)量 SortExpression=number / asp:CheckBoxField DataField=jiaocaike HeaderText=教材科 SortExpression=jiaocaike /