如题,在线等哦
解决方案 »
- 同一页面 两个Datalist之间传值问题
- 关于Spacebuilder二次开发的问题
- 动态添加的DropDownList的SelectedIndexChanged事件 大家都来指点下迷津
- XML解析错误:未找到元素 在线等
- 出现“用户代码未处理”错误?帮忙看下!
- 在datalist 如何绑定gridview数据
- C#从一个页面到另一个页面
- asp.net怎么提取一个外部网站返回的 xml 结果
- 请问csdn结贴时那个弹出的对话框是怎么做的?
- 如何将treeview控件改装成类似于PowerPoint中的组织结构图的形式?
- NET的RANGVALIDATE的问题
- asp.net + mssql 在一台机器上2.4G 512M 能同时处理多少个请求,或能同时维护多少个连接?
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>
<%@ 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>