如题,在线等哦

解决方案 »

  1.   

    <asp:DataGrid id="DataGrid1" runat="server" CssClass="Dgrd" Width="100%" AutoGenerateColumns="False"
    PageSize="5" AllowPaging="True" DataKeyField="Customer_ID">
    <HeaderStyle CssClass="DgrdHeader"></HeaderStyle>
    <Columns>
    <asp:TemplateColumn HeaderText="<input type='checkbox' id='cbSelect' onclick='selectAll(this);'>">
    <ItemTemplate>
    <input type="checkbox" value='<%#DataBinder.Eval(Container.DataItem,"Customer_ID")%>'>
    </ItemTemplate>
    </asp:TemplateColumn>
    <asp:BoundColumn DataField="Customer_ID" HeaderText="客户编号"></asp:BoundColumn>
    <asp:BoundColumn DataField="Customer_Name" HeaderText="客户名称"  ItemStyle-HorizontalAlign="Left"></asp:BoundColumn>
    <asp:BoundColumn DataField="BelongTo_Name" HeaderText="归属系统"></asp:BoundColumn>
    <asp:BoundColumn DataField="CustomerRate_Name" HeaderText="客户级别"></asp:BoundColumn>
    <asp:BoundColumn DataField="Customer_Zipcode" HeaderText="邮政编码"></asp:BoundColumn>
    <asp:BoundColumn DataField="Customer_Major_Tracer" HeaderText="主要责任跟踪人"></asp:BoundColumn>
    <asp:BoundColumn DataField="Customer_Minor_Tracer" HeaderText="次要责任跟踪人"></asp:BoundColumn>
    <asp:HyperLinkColumn Text="详细信息" HeaderText="详细信息" DataNavigateUrlField="Customer_ID" DataNavigateUrlFormatString="javascript:showDetail('CustomerInfo_More.aspx','{0}',1);"></asp:HyperLinkColumn>
    <asp:HyperLinkColumn Text="编辑" HeaderText="编辑" DataNavigateUrlField="Customer_ID" DataNavigateUrlFormatString="javascript:showDetail('CustomerInfo_More.aspx','{0}',2);"></asp:HyperLinkColumn>
    <asp:ButtonColumn Text="删除" HeaderText="删除" CommandName="Delete"></asp:ButtonColumn>
    </Columns>
    <PagerStyle CssClass="DgrdPager" Mode="NumericPages"></PagerStyle>
    </asp:DataGrid><script language="javascript">function selectAll(o){
        var checked = o.checked;
        for(var i = 0; i< o.form.elements.length; i++){
            var e = o.form.elements[i];
            if(e.type == 'checkbox' && e.id != o.id){
                if(e.checked != checked)
                    e.checked = checked;
            }
        } 
    }
    </script>
      

  2.   

    <%@ Page Language="VB" Debug="true" %>
    <%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Data.OleDb" %>
    <html>
    <script runat="server">
    dim MyConnection as OleDbConnectionSub Page_Load(Src as Object , E as EventArgs)
        MyConnection  = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath(".")+"/db/data.mdb")    SelectCheckBox()       If Not IsPostBack Then 
           BindData()
        End IfEnd SubSub SelectCheckBox()
        dim jsScript as String
        jsScript = "<script language=JavaScript> " 
        jsScript += "function select_deselectAll (chkVal, idVal) {" 
        jsScript += "var frm = document.forms[0];" 
        jsScript += " for (i=0; i<frm.length; i++) {" 
        jsScript += " if (idVal.indexOf ('chkCheckAll') != -1) {" 
        jsScript += " if(chkVal == true) {" 
        jsScript += " frm.elements[i].checked = true;" 
        jsScript += " } else {" 
        jsScript += " frm.elements[i].checked = false;" 
        jsScript += " }" 
        jsScript += " } else if (idVal.indexOf('chkDeleteThis') != -1) {" 
        jsScript += " if(frm.elements[i].checked == false) {" 
        jsScript += " frm.elements[1].checked = false;" 
        jsScript += " }"
        jsScript += " }"
        jsScript += " }" 
        jsScript += "}" 
        jsScript += "</scr"+"ipt>"    RegisterClientScriptBlock ("clientScript", jsScript) 
    End SubSub BindData() 
          dim myCommand as OleDbDataAdapter = new OleDbDataAdapter("SELECT * FROM tblFAQ", myConnection)
          dim ds as DataSet = new DataSet()
          myCommand.Fill(ds,"faq")
          MyDataGrid.DataSource = DS.Tables("faq").DefaultView
          MyDataGrid.DataBind()
    End SubSub btnDelete_Click(ByVal sender As Object, ByVal e As EventArgs)
        Dim myDataGridItem As DataGridItem
        Dim chkSelected As System.Web.UI.WebControls.CheckBox
        Dim selectID As String
        Dim getIDs As String    For Each myDataGridItem In MyDataGrid.Items
            chkSelected = myDataGridItem.FindControl("chkDeleteThis")
            If chkSelected.Checked Then
               selectID = CType(myDataGridItem.FindControl("lblFaqID"), Label).Text
               getIDs += selectID
       getIDs +=","
            End If
       Next 
       If getIDs = "" Then
          Response.Write("<script for=window event=onload>window.alert('Please Select you delete items!');</" & "script>")
       ElseIF getIDs <> "" Then
          'btnDelete.Attributes.Add("onclick", "return confirm('Are you Sure you want to delete this recoders?');")      DeleteRecord(Left(getIDs,getIDs.Length-1))  
       End If   Try    
            BindData()  
       Catch
            Mydatagrid.CurrentpageIndex=MyDataGrid.pagecount-1
            BindData()   
        End Try
    End Sub Sub DeleteRecord(DeleteIDs)   
        Dim cmdDelID As OleDbCommand
        Dim DelID As String = "DELETE FROM tblFAQ WHERE faqid IN ("& DeleteIDs &")"    cmdDelID = New OleDbCommand(DelID, MyConnection)    cmdDelID.Connection.Open()
        cmdDelID.ExecuteNonQuery()
        cmdDelID.Connection.Close()
    End SubSub Mydatagrid_PageIndexChanged(s as object,e as DataGridPageChangedEventargs)
        MyDataGrid.CurrentPageIndex=e.newPageIndex
    BindData()
    End Sub
    </script>
    <body>
       <h3><font face="Verdana">Simple SELECT to a DataGrid Control
       </font></h3>
    <Form runat="server">
    <asp:Button id="btnDelete" Text="Delete Items" OnClick="btnDelete_Click" runat="server"/>
    <ASP:DataGrid id="MyDataGrid" runat="server"
          Width="700"
          BackColor="#ccccff" 
          BorderColor="black"
          ShowFooter="false" 
          CellPadding=3 
          CellSpacing="0"
          Font-Name="Verdana"
          Font-Size="8pt"
          HeaderStyle-BackColor="#aaaadd"
      AutoGenerateColumns="False"
      AllowPaging="true" 
      PageSize="50" 
      OnPageIndexChanged="Mydatagrid_PageIndexChanged" >
      <PagerStyle Mode="NumericPages" Font-Bold="true" BackColor="#C9D8FA" HorizontalAlign="right"> 
      </PagerStyle>
          <Columns>
              <asp:TemplateColumn>
                    <HeaderTemplate>
                           <asp:CheckBox ID="chkCheckAll" OnClick="javascript: return select_deselectAll (this.checked, this.id);" runat="server"/> 
                           <font face="Webdings" color="white" size="4">a</font>
                    </HeaderTemplate>
                    <ItemTemplate>
                           <asp:CheckBox ID="chkDeleteThis" OnClick="javascript: return select_deselectAll (this.checked, this.id);" runat="server"/>
                     </ItemTemplate>
               </asp:TemplateColumn>
               <asp:TemplateColumn HeaderText="FaqID">
                    <ItemTemplate>
                         <asp:Label ID="lblFaqID" Text='<%# Container.DataItem("faqid") %>' Runat="server"/>
                     </ItemTemplate>
               </asp:TemplateColumn>
             <asp:BoundColumn DataField="description" HeaderText="Description"/>
     <asp:BoundColumn DataField="viewcount" HeaderText="Viewcount"/>
           </Columns>
    </asp:DataGrid>
    </Form>
    </body>
    </html>