【asp.net读取excel中的数据并绑定在gridview】教程文章相关的互联网学习教程文章

ASP.NET Gridview与checkbox全选、全不选实现代码

1. 页面 在onclick事件中 "传自己" 代码如下:<asp:TemplateField HeaderText="全选"> <HeaderTemplate> <input type="checkbox" id="CheckBox1" name="CheckBox1" onclick="GetAllCheckBox(this)" /> 全选 </HeaderTemplate> <ItemTemplate> <asp:CheckBox ID="CheckBox2" runat="server"/> </ItemTemplate> <ItemStyle HorizontalAlign="Center" Width="100px" /> </asp:TemplateField> 2.编写JS代码 代码如下:<script type="t...

asp.net 扩展GridView 增加单选按钮列的代码

代码如下:/// <summary> /// 单选按钮列 /// </summary> /// <remarks> /// 如果没有设置GroupName,则使用GridView的ID作为GroupName /// 如果没有设置DataField,则使用RowIndex作为Value /// 允许设置DataFormatString格式化数据 /// </remarks> [AspNetHostingPermission(SecurityAction.Demand, Level = AspNetHostingPermissionLevel.Minimal)] public class RadioButtonSelectField : DataControlField { /// <summary> ///...

asp.net GridView控件中实现全选的解决方案

第一种:利用客户端控件实现 JS: 代码如下:<script type="text/javascript"> function checkAll() { var checklist=document.getElementsByTagName("input"); for(var i=0;i<checklist.length;i++) { if(checklist[i].type=="checkbox") { checklist[i].checked=document.form1.ck.checked; } } } </script> GridView控件: 代码如下:<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" > <Columns> <as...

Asp.net中的GridView导出遇到的两个问题和解决方法

对于GridView导出的内容的代码大致如下: Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls"); Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.ContentType = "application/ms-excel"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new Syste...

asp.net Gridview行绑定事件新体会

在网上搜了一下事件执行顺序,并经过测试在有分页的情况下是不正确的。事件执行顺序: 一、GridView 显示绑定的数据(默认为5行): 代码如下:DataBinding RowCreated:Header[0] RowDataBound RowCreated:DataRow[1] RowDataBound RowCreated:DataRow[2] RowDataBound RowCreated:DataRow[3] RowDataBound RowCreated:DataRow[4] RowDataBound RowCreated:DataRow[5] RowDataBound RowCreated:Footer[6] //不管有没有页角行,该事件...

asp.net 不用GridView自带删除功能,删除一行数据

前台代码: 代码如下:<asp:GridView ID="GridLog" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="ID" BorderColor="#333" BorderStyle="solid" BorderWidth="1" OnRowDeleting="PublicGridRowDeleting" GridLines="None" Width="98%" ForeColor="#333333"> <FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" /> <Columns> <asp:BoundField DataField="ID" HeaderText="ID" Inse...

asp.net GridView控件鼠标移动某行改变背景颜色(方法一)【图】

代码如下:using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class Demo19 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == ...

asp.net GridView控件中模板列CheckBox全选、反选、取消【图】

代码如下:using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class Demo18 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs...

asp.net GridView 删除时弹出确认对话框(包括内容提示)【图】

效果图: html代码 代码如下:<table align="center" bgcolor="#c0de98" border="0" cellpadding="0" cellspacing="1" width="99%"> <tr> <th colspan="2"> GridView演示</th> </tr> <tr> <td colspan="2" style="width: 100%;" > <asp:GridView ID="GridView" runat="server" Width="100%" AutoGenerateColumns="False" AllowPaging="True" OnPageIndexChanging="GridView_PageIndexChanging" PageSize="12" OnRowDeleting="GridVi...

asp.net GridView排序简单实现

前台: 代码 代码如下:<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewSort.aspx.cs" Inherits="GridViewSort" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>GridView排序简单实现</title> </head> <body> <form id="form1" runat="server"> ...

asp.net 获取Gridview隐藏列的值

在Gridview 的 RowCreated事件中书写如下代码: 代码如下:void GridView1_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Header) { //隐藏第1列 e.Row.Cells[0].Visible = false; //可以根据需要隐藏更多的列 } } 因为在RowCreated事件(隐藏)在绑定时候发生,所以这样就即能将数据绑定到列上,又隐藏该列,所以可以访问到隐藏列的...

asp.net gridview指定某一列滚动

//基本代码设计 <div id="div-datagrid"> <asp:DataGrid id="DataGrid1" runat="server" CssClass="Grid" UseAccessibleHeader="True"> <AlternatingItemStyle CssClass="GridAltRow"></AlternatingItemStyle> <ItemStyle CssClass="GridRow"></ItemStyle> <Columns> <asp:BoundColumn DataField="Name" HeaderText="Name" ItemStyle-Wrap="False"></asp:BoundColumn> <asp:BoundColumn DataField="Address" HeaderText="Address" ...

asp.net 合并GridView中某列相同信息的行(单元格)【图】

解决方法如下(写在公共模块里,定义为静态方法方便调用): 代码如下:/// <summary> /// 合并GridView中某列相同信息的行(单元格) /// </summary> /// <param name="GridView1">GridView</param> /// <param name="cellNum">第几列</param> public static void GroupRows(GridView GridView1, int cellNum) { int i = 0, rowSpanNum = 1; while (i < GridView1.Rows.Count - 1) { GridViewRow gvr = GridView1.Rows[i]; for (+...

C#精髓 GridView72大绝技 学习gridview的朋友必看【图】

快速预览:GridView无代码分页排序GridView选中,编辑,取消,删除GridView正反双向排序GridView和下拉菜单DropDownList结合GridView和CheckBox结合鼠标移到GridView某一行时改变该行的背景色方法一鼠标移到GridView某一行时改变该行的背景色方法二GridView实现删除时弹出确认对话框GridView实现自动编号GridView实现自定义时间货币等字符串格式GridView实现用“...”代替超长字符串GridView一般换行与强制换行GridView显示隐藏某一...

asp.net+jquery Gridview的多行拖放, 以及跨控件拖放

代码如下:<html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <script type="text/javascript" src="jquery-1.3.2.js"></script> <script type="text/javascript" src="jquery-ui-1.7.2.custom.js"></script> <script type="text/javascript"> //=================================== //dragg and drop sample program //authored by gujinsong@trans-cosmos //2009-11-11 //===================...