100分收集DataGrid使用技巧[Asp.Net]

自己占楼先
在DataGrid创建项时(ItemCreated事件)使用Attributes属性为按钮添加确认提示框TableCell        表示Table控件中的单元格1.系统自动生成的删除列
private void DGMcusFind_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
   switch (e.Item.ItemType)
   {
    case ListItemType.Item:
    case ListItemType.AlternatingItem:
    case ListItemType.EditItem:
     TableCell Tcell= e.Item.Cells[1];//找到系统自动生成的删除列，此处为第二列。下标是从0开始的，所以为1
     ((LinkButton)Tcell.Controls[0]).Attributes["OnClick"]="javascript:return confirm('你确定要删除吗？');"; //找到删除列按钮，添加提示框
     break;
   }
  }2.手动添加的列
Asp文件<asp:DataGrid id="DGMcusFind" Runat="server">
<Columns>
<asp:ButtonColumn Text="详细资料" CommandName="Select"></asp:ButtonColumn>
<asp:TemplateColumn>
<ItemTemplate>
<asp:Button ID="delete" Runat="server" Text="删除"></asp:Button>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:Datagrid>CS文件
private void DGMcusFind_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
   switch (e.Item.ItemType)
   {
    case ListItemType.Item:
    case ListItemType.AlternatingItem:
    case ListItemType.EditItem:
          ((Button)e.Item.FindControl("delete")).Attributes["OnClick"]="javascript:return  confirm('你确定要删除吗？');";  //delete为添加按钮的ID
    break;
   }
  }

找到dataGrid中的按钮
系统自动生成的按钮
  DataGrid会自动生产选择、编辑、更新、取消、删除这几个按钮。要找他们的方法基本都是一样的，主要区别在
状态的判断。更新：private void dataJG_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.EditItem)
{
  ((LinkButton)e.Item.Cells[0].Controls[0]).CausesValidation = false;
}
}只有处于编辑状态datagrid中才会有更新按钮。因为是第一列，所以是e.Item.Cells[0]。更新按钮是编辑列中的第一个按钮，所以e.Item.Cells[0].Controls[0]。取消：同理取消按钮应该是  e.Item.Cells[0].Controls[1]。
编辑：在普通情况下才有编辑按钮
Switch(e.Item.ItemType)
{
case ListItem.AlternatingItem:
case ListItem.Item:
  ((LinkButton)e.Item.Cells[0].Controls[0])).CauseValidation = true;
  break;
}

选择：
选择按钮最简单
((LinkButton)e.Item.Cells[0].Controls[0])).CauseValidation = true;

DataGrid资料这个Blog的主人收集了很多
http://www.cnblogs.com/iCeSnaker/archive/2004/07/31/29017.aspx

DataGrid双向排序方法
1.将DataGrid的AutoSorting设为true2.将DataGrid的OnSortCommand属性设置为RESULT_SORT3.在代码页中添加DataSet ds;DataTable dt;DataView dv;  public void RESULT_SORT(Object sender,DataGridSortCommandEventArgs e)
  {
   ViewState["SortField"]=(String)e.SortExpression;
   switch((String)ViewState["SortDirection"])   // 双向排序
   {
    case("ASC"):
     ViewState["SortDirection"]="DESC";
     break;
    case("DESC"):
     ViewState["SortDirection"]="ASC";
     break;
    default:
     ViewState["SortDirection"]="ASC";
     break;
   }
   dv=dt.DefaultView;
   dv.Sort=ViewState["SortField"]+" "+ViewState["SortDirection"];
   DataGrid1.DataSource=dv;
   DataGrid1.DataBind();  }

将xml作为DataGrid 操作（Sort, Edit, Delete）我们将显示如何将一个xml文件作为datagrid,这样对其的排序，编辑，等操作将是非常简单的事。
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Data" %>
<html>
<script language="VB" runat="server">Sub Page_Load(Src As Object, E As EventArgs)
        If Not (IsPostBack)
            DataLoad("isbn")
        End If
End SubSub DataLoad(parmsort as string)
         Dim ds As New DataSet
        Dim FS As New FileStream(Server.MapPath("books.xml"), FileMode.Open)
        ds.ReadXml(FS)
        MyDataGrid.DataSource = new DataView(ds.Tables(0))
        MyDataGrid.DataBind()
        FS.close()
END SUBSub DataSort(Src As Object, E As DataGridSortCommandEventArgs)
    ' Bug if we sort, then Edit Item Becomes Wrong
    IF MyDataGrid.EditItemIndex=-1 THEN
        DataLoad(e.sortexpression)
    ELSE
        response.write ("Can't sort until editing is done!")
    END IF
End Sub   Sub DataDelete(Sender As Object, E As DataGridCommandEventArgs)
    DIM deletekey as string
    IF MyDataGrid.EditItemIndex=-1 THEN
        deletekey=MyDataGrid.DataKeys(CInt(E.Item.ItemIndex))
        response.write ("deleted " & deletekey)
    ELSE
        response.write ("Can't delete until editing is done!")
    END IF
END SUB
Sub DataEdit(Sender As Object, E As DataGridCommandEventArgs)
        DIM editkey as string
        MyDataGrid.EditItemIndex = Cint(E.Item.ItemIndex)
        editkey=MyDataGrid.DataKeys(CInt(E.Item.ItemIndex))
        'response.write ("To Be Edited" & editkey)
        DataLoad("")
End SubSub DataCancel(Sender As Object, E As DataGridCommandEventArgs)
        MyDataGrid.EditItemIndex = -1
        response.write ("edit was cancelled")
        DataLoad("")
End SubSub DataUpdate(Sender As Object, E As DataGridCommandEventArgs)
        DIM editkey as string
        MyDataGrid.EditItemIndex = -1
       editkey = MyDataGrid.DataKeys(CInt(E.Item.ItemIndex))
       response.write ("To Be Updated " & editkey)
        DataLoad("")
       ' howmanycols = E.Item.Cells.Count
End Sub</script><body><h3><font face="Verdana">The Best Books Ever</font>
<span runat="server" id="MySpan"/></h3><form runat="server">
<ASP:DataGrid id="MyDataGrid" runat="server"   AllowSorting="true"
   OnSortCommand="DataSort"
   OnDeleteCommand="DataDelete"
   OnEditCommand="DataEdit"
   OnCancelCommand="DataCancel"
   OnUpdateCommand="DataUpdate"

    DataKeyField="isbn"   Width="100%"
   BackColor="white"
   BorderColor="black"
   ShowFooter="false"
    CellPadding=3
   CellSpacing="0"
   Font-Name="Verdana"
   Font-Size="8pt"
   Headerstyle-BackColor="lightblue"
   Headerstyle-Font-Size="10pt"
   Headerstyle-Font-Style="bold"
   MaintainState="true"
    >

    <Columns>
      <asp:ButtonColumn Text="Delete Book" CommandName="Delete"/>

      <asp:EditCommandColumn EditText="Edit" CancelText="Cancel" UpdateText="Update" ItemStyle-Wrap="false"/>
    </columns>
</ASP:DataGrid></form>

</body>
</html>
xml的源文件：
<books>
    <book>
    <isbn>0070653623</isbn>
    <author>Jack Trout, Steve Rivkin</author>
    <title>The Power of Simplicity</title>
    <category>selfhelp</category>
    <comments>A Real Fun Read</comments>
    </book>

    <book>
    <isbn>0887306667</isbn>
    <author>Al Reiss, Jack Trout</author>
    <title>22 Immutable Laws of Marketing</title>
    <category>eting</category>
    <comments>This team offers more profound advice about creating world class eting campaigns that will be viable for a hundred years.</comments>
    </book>    <book>
    <isbn>0887309372</isbn>
    <author>Al Reiss, Laura Reiss</author>
    <title>22 Immutable Laws of Branding</title>
    <category>eting</category>
    <comments>This book is great for people who used 22 Immutable Laws of Marketing to build a brand and now want to strengthen that brand.</comments>
    </book>

    <book>
    <isbn>0679757651</isbn>
    <author>Tom Peters</author>
    <title>Circle of Innovation</title>
    <category>eting</category>
    <comments>His most recent book is his best by far!</comments>
    </book>

    <book>
    <isbn>0884270610</isbn>
    <author>Eli Goldthrait</author>
    <title>The Goal</title>
    <category>management</category>
    <comments>Advocate of Theory of Constraints as applied to managment and optimization.</comments>
    </book>    <book>
    <isbn>068485600X</isbn>
    <author>Jeff Cox, Howard Stevens</author>
    <title>Selling the Wheel</title>
    <category>management</category>
    <comments>Excellent Treatise/Novel on the entire Sales Cycle</comments>
    </book>    <book>
    <isbn>0672316498</isbn>
    <author>Alan Cooper</author>
    <title>The Inmates Are Running The Asylum</title>
    <category>management</category>
    <comments>The father of Visual Basic and creator of the new art of Interaction Design - very valuable in designing websites. Basically the worlds most  cutting edge thinker in User Interface design aimed at simplifying software use.</comments>
    </book>

</books>

你们几个说的是DataGrid的绑定数据用法？我怎么看不明白呀？
我就会2种方法视图绑定，设置隐藏主绑定，模班绑定，超级连接绑定..
另外就是用datetable 设置daterow 逐行绑定。
还有别的方法吧，盼望大家告诉我。

创建功能完备的DataGrid你对ASP.NET的DataGrid的编辑功能是不是感到很失望呢？我们就在本文里向你介绍一种利用.NET基本类型库构建自己的全功能的DataGrid。在基于WEB的应用中，直接编辑数据，并更新到数据库可以得到一种意想不到的效果。ASP.NET向我们提供了许多基类，以帮助我们创建我们自己的全功能的DataGrid。本文就利用System.Text类创建我们的Datadrid，然后利用System.Data.SqlClient类和数据库交互，在使用之前，必须先把它们导入到应用程序中。
我们首先创建一个基本表单，上面放两个控件，一个是更新按钮，另一个是显示数据的容器。利用高效的StringBuilder类来生成数据网格的HTML字符串。先看看得到数据的代码：

private  DataSet  getDS()
{
System.Data.SqlClient.SqlConnection  myConn;
string  conn  =  "server=(localhost)\\NetSDK;database=Northwind;Trusted_Connection=yes";
myConn  =  new  System.Data.SqlClient.SqlConnection(conn);
ds  =  new  DataSet();
ds.CaseSensitive  =  true;
SqlCommand  sqlcmd  =  new  System.Data.SqlClient.SqlCommand();
sqlcmd.Connection  =  myConn;
sqlcmd.CommandText  =  "Select  CustomerID,CompanyName,  ContactName,ContactTitle  from  Customers";
da  =  new  SqlDataAdapter(sqlcmd);
SqlCommandBuilder  SCB  =  new  SqlCommandBuilder(da);
da.SelectCommand  =  sqlcmd;
da.TableMappings.Add("Table","Customers");
da.Fill(ds);
return  ds;
}

DataSet返回数据库中数据的列和行，就象一张表格。为了填充网格，我们必须先写出所需的HTML，构建不同的列对象，然后遍历整个数据表，利用StringBuilder类产生出页面表格的HTML代码。
private  void  writeGrid()
{
DataTable  dt  =  getDS().Tables[0];
DataRow  dr;
StringBuilder  sb  =  new  StringBuilder();
//HTML表格开始
sb.Append  ("<table  class='tblDataGrid'  borderColor='gray'  cellSpacing='1'
cellPadding='1'  border='1'  width='825px'  >");
int  col  =  0;  //列数变量

for(int  i=0;  i<dt.Rows.Count-1;i++)
{
dr  =  dt.Rows[i];
col=0;
sb.Append  ("<tr  class='trDataGrid'  name=tr"  +  i  +  "  id=tr"  +  i  +  "  >");
//input文本框
sb.Append("<td  class='tdDataGrid'  style=width:185px  nowrap  >");
sb.Append("<input  class='txtDataGrid'  type=text  Id='df"  +  i  +  "-"  +  col  +  "'
Name='df"  +  i  +  "-"  +  col  +  "'  value='"  +  dr[col].ToString()  +  "'
size='20'  onChange=rowChange('"  +  i  +  "')></input>  ");
sb.Append("</td>");
col++;
sb.Append("<td  class='tdDataGrid'  style=width:185px  nowrap  >");
sb.Append("<input  class='txtDataGrid'  type=text  Id='df"  +  i  +  "-"  +  col  +  "'
Name='df"  +  i  +  "-"  +  col  +  "'  value='"  +  dr[col].ToString()  +  "'
size='20'  onChange=rowChange('"  +  i  +  "')></input>  ");
sb.Append("</td>");
col++;
sb.Append("<td  class='tdDataGrid'  style=width:185px  nowrap  >");
sb.Append("<input  class='txtDataGrid'  type=text  Id='df"  +  i  +  "-"  +  col  +  "'
Name='df"  +  i  +  "-"  +  col  +  "'  value='"  +  dr[col].ToString()  +  "'
size='20'  onChange=rowChange('"  +  i  +  "')></input>  ");
sb.Append("</td>");
col++;
sb.Append("<td  class='tdDataGrid'  style=width:185px  nowrap  >");
sb.Append("<input  class='txtDataGrid'  type=text  Id='df"  +  i  +  "-"  +  col  +  "'
Name='df"  +  i  +  "-"  +  col  +  "'  value='"  +  dr[col].ToString()  +  "'
size='20'  onChange=rowChange('"  +  i  +  "')></input>  ");
sb.Append("</td>");
col++;
//隐藏表单域，保存要更新的数据行的状态
sb.Append("<input  type=hidden  id=hid'"  +  i  +"'  Name='hid"  +  i+  "'
value='existing'  >");
//关闭行标记
sb.Append("</tr>");
}
sb.Append("</table>");
//显示出表格
Output.InnerHtml  =  sb.ToString();
}

在上面的代码中，我们以数据的行、列位置来命名网格元素，这样可以方便我们对网格进行操作，也可以避免担心列数量的多少和列名字的变化。现在，我们已经创建了一个数据网格（DataGrid），并且创建了控制元素，根据创建方式的不同，这些控制元素既可以是基于客户端的，也可以是基于服务器端的，文本框的OnChange事件调用rowChange函数，来更新每行隐藏表单域的值。rowChange函数如下：

function  rowChange(element)
{
eval("document.frmMain.hid"  +  element  +  ".value  =  'update'");
}

为了把我们更新过的数据写回数据库，我们只需要遍历那些隐藏表单域的值改变了那些行。利用DataTable的Select方法得到DataSet中变化的行，并把更新的数据写到DataSet。

private  void  Update()
{
//创建DataTable
DataTable  udt  =  getDS().Tables["Customers"];
DataRow[]  dr;
//遍历表单元素
int  row=0;//行数
while  (Request.Form["hid"  +  row]  !=  null)
{
//如果有数据更新，就进行更新操作
if  (Request.Form["hid"  +  row]  ==  "update")
{
int  col=0;//列数

//找到变化的行，并更新DataTable
string  strExp  =  "CustomerID  =  '"  +  Request.Form["df"  +  row  +  "-"  +  col]+"'";
dr  =  udt.Select(strExp);
//更新开始
dr[0].BeginEdit();
dr[0]["CustomerID"]=  Request.Form["df"  +  row  +  "-"  +  col];
col++;
dr[0]["CompanyName"]  =  Request.Form["df"  +  row  +  "-"  +  col  ];
col++;
dr[0]["ContactName"]  =  Request.Form["df"  +  row  +  "-"  +  col];
col++;
dr[0]["ContactTitle"]  =  Request.Form["df"  +  row  +  "-"  +  col];
dr[0].EndEdit();
}
row++;  //行数加一
}
}

然后，我们调用DataAdapter的Update方法,把更新后的数据写回到数据库。注意上面的代码：当我们创建DataSet时，我们使用了SqlCommandBuilder对象，如果我们设定了SqlDataAdapter的selectCommandProperty，SqlCommandBuilder对象会自动产生单个表的Transact-SQL语句。
private  void  writeChanges()
{
da.Update(ds,  "Customers");
}

一旦我们要更新的数据写回到了数据库，我们就可以调用getDataGrid函数来重新显示变化的DataGrid。
希望本文在如何使用不同的ASP.NET提供的类来创建全功能的DataGrid上会给你一些启发。

在DataGrid中创建一个弹出式窗口这篇文章来自DotNetJunkie的提议。他最初写信要求我们提供一个关于如何创建在DataGrid 中使用HyperLinkColumn的例子，可以在用户点击这一列后打开一个新窗口，显示出此列的详细内容。在此之前我们曾经通过email回答他们，他建议我们将这个方法加入他们的指南中，于是，就有了这篇文章。像我们原来的文章一样，它很简单，但是简单的包含代码姆椒ɡ梢愿行У仄舴⒖⒄摺?BR>　　这个例子包含两个WebForms和一个css文件（所有的代码都可以下载）－－第一个WebForm包含一个展示从Northwind库中读出的产品列表的DataGrid，hyperlink的states设为“SeeDetails”,一旦这个链接被点击，JavaScript片段 Window.Open方法就会被调用.用户想获得的关于产品的ProductID做为参数包含在URL中.包含另一个DataGrid的第二个Webforms向用户列示他选中产品的所有具体细节。让我们来看一下datagrid-open.aspx和datagrid-open.aspx.cs
datagrid-open.aspx
<%@ Page language="c#" Codebehind="datagrid-open.aspx.cs" AutoEventWireup="false" Inherits="study.datagrid_open" %>
<HTML>
<HEAD>
<title>datagrid-open</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body>
<center>
<form runat="server" ID="Form1">
<asp:datagrid id="DataGrid1" runat="server" Font-Size="12" AutoGenerateColumns="False">
<Columns>
<asp:BoundColumn DataField="ProductID" HeaderText="Product ID" HeaderStyle-CssClass="HEADERSTYLE" ItemStyle-CssClass="ITEMSTYLEDEFAULT" />
<asp:BoundColumn DataField="ProductName" HeaderText="Product Name" HeaderStyle-CssClass="HEADERSTYLE" ItemStyle-CssClass="ITEMSTYLEDEFAULT" />
<asp:hyperlinkcolumn DataTextFormatString="Show Details..." DataTextField="ProductID" DataNavigateUrlField="ProductID" DataNavigateUrlFormatString="javascript:var win = window.open("datagrid-show.aspx?ProductID={0}",null,"width=700,height=200");" HeaderText="See Details" HeaderStyle-CssClass="HEADERSTYLE" ItemStyle-CssClass="ITEMSTYLEHYPERLINK" />
</Columns>
</asp:datagrid>
</form>
</center>
</body>
</HTML>datagrid-open.aspx.cs
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace study
{
/// <summary>
/// datagrid_open 的摘要说明。
/// </summary>
public class datagrid_open : System.Web.UI.Page
{
  protected System.Web.UI.WebControls.DataGrid DataGrid1;
  protected System.Web.UI.HtmlControls.HtmlForm Form1;
  #region User Defined Code
  private void Page_Load(object sender, System.EventArgs e)
{
   if ( ! this.IsPostBack )
    this.BindData();
  }  protected void BindData()
  {
   SqlCommand cmd = new SqlCommand( "SELECT TOP 10 ProductID, ProductName FROM Products", con("Server=dwserver; DataBase=Northwind; User Id=sa; Password=123456"));
   this.DataGrid1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);
   this.DataGrid1.DataBind();
  }
  protected SqlConnection con(System.String ConnectionString )
  {
   SqlConnection c = new SqlConnection( ConnectionString );
   c.Open();
   return c;
  }
  #endregion  #region Web Form Designer generated code
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.Load += new System.EventHandler(this.Page_Load);
  }
  #endregion
}
}　　除了DataNavigateUrlFormatString外确实没什么困难的，你可以注意到我实际上直接使用了一个javascript片段（注：你也可以简单地创建一个.js文件或在WebForm中使用<script></script>），javascript如此普及，所以这里不再详细讲解。功能上，它打开一个新的窗口，带ProductID查询字串的datagrid_show.aspx，ProductID的值来自我们的数据源。我们可以看这两个文件：
datagrid_show.aspx
<%@ Page language="c#" Codebehind="datagrid-show.aspx.cs" AutoEventWireup="false" Inherits="study.datagrid_show" %>
<HTML>
<HEAD>
<title>datagrid-show</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body>
<P align="left">
<asp:DataGrid HeaderStyle-CssClass="HEADERSTYLE" ItemStyle-CssClass="ITEMSTYLEDEFAULT" runat="server" id="DataGrid1" Font-Size="8" Height="50" Width="675"></asp:DataGrid></P>
<p align="center">
<a href="JavaScript:window.close()">close window</a>
</p>
</body>
</HTML>datagrid_show.aspx.cs
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace study
{
/// <summary>
/// datagrid_show 的摘要说明。
/// </summary>
public class datagrid_show : System.Web.UI.Page
{
  protected System.Web.UI.WebControls.DataGrid DataGrid1;
  #region User Defined Code
  private void Page_Load(object sender, System.EventArgs e)
  {
   if ( ! this.IsPostBack )
    this.BindData();
  }  protected void BindData()
  {
   SqlCommand cmd = new SqlCommand( "SELECT * FROM Products WHERE ProductID = @ProductID", con("Server=dwserver; DataBase=Northwind; User Id=sa; Password=123456"));
   cmd.Parameters.Add(new SqlParameter("@ProductID", SqlDbType.VarChar, 200));
   cmd.Parameters["@ProductID"].Value = Request["ProductID"].ToString();
   this.DataGrid1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);
   this.DataGrid1.DataBind();
  }    protected SqlConnection con(System.String ConnectionString )
  {
   SqlConnection c = new SqlConnection( ConnectionString );
   c.Open();
   return c;
  }
  #endregion  #region Web Form Designer generated code
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.Load += new System.EventHandler(this.Page_Load);
  }
  #endregion
}
}其实很简单的，朋友可以试试吧。

让Asp.NET的DataGrid可排序、可选择、可分页
http://blog.csdn.net/lihonggen0/archive/2004/05/17/13645.aspx
在DataGrid页眉上添加全选的CheckBox控件
http://blog.csdn.net/lihonggen0/archive/2004/08/13/74202.aspx

http://www.cnblogs.com/iCeSnaker/archive/2004/07/31/29017.aspx

the famous datagrid girl site:http://www.datagridgirl.com/articles.aspx

查看http://www.datagridgirl.com/，这儿有很多关于datagrid实用的文章

datagrid中实现改变某行的背景色，点击任一列能实现超连接？private void datagrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
e.Item.Attributes["onmouseover"]="this.name=this.style.backgroundColor;this.style.backgroundColor='yellow';";
e.Item.Attributes["ondbclick"]="window.open('***.aspx?id=" + e.Item.Cells[0].Text + "','newwin','')";
}
}

怎么往DataGrid里添加一个文本框在一般状态下DataGrid显示的内容都无法直接更改。我想用一个TextBox来显示内容，那这样就能修改了，而不需要切换到编辑模式。手动绑定我知道怎么写，但是列一多写起来就麻烦了。<Columns>
<asp:TemplateColumn HeaderText="SFJR">
<ItemTemplate>
<asp:TextBox id=txtTJJG BorderStyle="Groove" Text='<%# DataBinder.Eval(Container.DataItem,"SFJR") %>' Runat="server">
</asp:TextBox>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>有其他办法没有？？？？

DataGrid网上资源搜集！
A Remedy for DataGrid Vertigo  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=763
A Truly Excel-like Grid Control  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/Data02142002.asp?frame=true
Accessing Datagrid Information  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=355
Adding a "Totals" Field in a Datagrid  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=96
Adding a Blank Row to a Datagrid (Used to INSERT rather than UPDATE)  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=186
Adding a DropDownList to an Editable Datagrid  http://www.4guysfromrolla.com/webtech/050801-1.shtml
Adding a New Row in a Datagrid  http://www.dotnetbips.com/displayarticle.aspx?id=125
Alphabetic Paging in a Datagrid  http://www.dotnetbips.com/displayarticle.aspx?id=124
Alphabeting Paging  http://aspnet101.com/aspnet101/aspnet/codesample.aspx?code=alphanosort
ASP.NET & Databases : Part 6  http://www.aspalliance.com/wisemonk/view.aspx?id=AD111201
ASP.NET & Databases : Part 7  http://www.aspalliance.com/wisemonk/view.aspx?id=AD121101
ASP.NET Data Shaping  http://msdn.microsoft.com/msdnmag/issues/02/03/cutting/cutting0203.asp
ASP.NET Datagrid Column Sorting  http://www.aspnextgen.com/tutorials.aspx?tutorialid=52
ASP.NET Datagrid Paging - Custom Paging w/ Caching & Numeric Links  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=287
ASP.NET Datagrid Paging Part 1  http://www.aspnextgen.com/tutorials.aspx?tutorialid=48
ASP.NET DatGrid Paging Part 2 - Custom Paging  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=50
ASP.NET: Adding dynamic content to a Datagrid Footer  http://www.aspalliance.com/aldotnet/examples/dgfooter.aspx
ASP.NET: Master/Detail View using a DropDownList and a Datagrid  http://www.aspalliance.com/aldotnet/examples/masterdetail_ddl_datagrid.aspx
ASP.NET: Web Forms Let You Drag And Drop Your Way To Powerful Web Apps  http://msdn.microsoft.com/msdnmag/issues/01/05/WebForms/WebForms.asp
Auto-Scrolling Datagrid  http://aspalliance.com/aldotnet/examples/dgautoscroll.aspx
Bidirectional Sorting with ViewState Disabled  http://www.aspalliance.com/olson/articles/Bisort.aspx
Bind a Datagrid to a User Defined Class  http://www.eraserver.net/robertlair/example_gridembeddedclass.aspx
BUG: DataGrid Web Server Control Wraps When Wrap Property Is Set to False  http://support.microsoft.com/default.aspx?scid=kb;EN-US;323169
Build a Variety of Custom Controls Based on the Datagrid Control  http://msdn.microsoft.com/msdnmag/issues/01/10/cutting/cutting0110.asp
Building a DataEntry Form with the Datagrid  http://tripleasp.net/tutorial.aspx?navid=25
Building a Master/Detail Datagrid  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=135
Building a Master/Detail Datagrid Part II  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=138
CheckBoxes  http://www.mastercsharp.com/article.aspx?ArticleID=81&&TopicID=2
Code Snippet - Datagrid with line numbers  http://www.aspalliance.com/aldotnet/examples/dgwithrownumbers.aspx
Conditional Datagrid Item and using checkboxes  http://www.aspfree.com/aspnet/ConditionalDataGridItem.aspx
Confirm Delete Inside A Datagrid  http://www.aspalliance.com/aldotnet/examples/cd.aspx
Coping with a New Beta - Data Server Control Templates and Editing  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=84
Creating a Custom DatagridColumn  http://aspnet.4guysfromrolla.com/articles/100202-1.2.aspx
Creating a Details Popup Window Grid in a Datagrid  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=219
Creating Datagrid Programmatically  http://www.dotnetbips.com/displayarticle.aspx?id=66
Creating Datagrid Templated Columns Dynamically - Part I  http://www.dotnetbips.com/displayarticle.aspx?id=84
Creating Datagrid Templated Columns Dynamically - Part II  http://www.dotnetbips.com/displayarticle.aspx?id=85
Creating Templated DataGrid Controls Using Visual Studio .NET  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=332
Creating Web Server Control Templates Programmatically  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vstechart/html/vbtchCreatingWebServerControlTemplatesProgrammatically.asp
Custom ASP.NET Datagrid Paging With Exact Count  http://www.4guysfromrolla.com/webtech/082901-1.shtml
Custom Datagrid with Editing  http://aspalliance.com/andrewmooney/default.aspx?page=19
Custom Paging  http://www.fawcette.com/dotnetmag/2002_10/magazine/columns/architecting/default_pf.asp
Custom Paging Solution  http://www.fawcette.com/dotnetmag/2002_10/magazine/columns/architecting/
Custom Web Data Reporting  http://msdn.microsoft.com/msdnmag/issues/01/07/cutting/cutting0107.asp
Data & ASP.NET  http://www.aspalliance.com/wisemonk/view.asp?vtype=article&id=AD081901
Databinding and XML  http://www.aspnextgen.com/tutorials.aspx?tutorialid=12
Databinding Custom Classes  http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=328
DataFormatStrings  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWebUIWebControlsBoundColumnClassDataFormatStringTopic.asp

问大家个问题，DataGrid分页时取出数据是一次全部取出还是按页码来取出呢？？

------
DataGrid分页时取出数据是一次全部取出还是按页码来取出呢
-------
两种都可以，看你的写法

双击编辑单元格内容http://blog.csdn.net/czhenq/archive/2004/09/24/115908.aspx

datagrid 结构
http://blog.csdn.net/latitude/category/12135.aspx

在DataGrid中添加Radio（单选按钮）列 http://blog.csdn.net/net_lover/archive/2004/07/17/43764.aspx

待在技术区2个月，升星了，正好下月起，工作忙了，没多少时间给各位解答了，以下是我技术收藏：（各种收藏都有），也许给你们会有帮住，谢谢！！！（本人还有一个疑问，就是对于做WEB控件的时候，有的属性嵌到三层或以上，就没有用了，例如：Iimageurl的对话框），算了，大家有好的也加呀！！
http://blog.csdn.net/rickjelly2004
他们两的资料很全的，看看吧！
http://blog.csdn.net/lihonggen0
http://blog.csdn.net/net_lover
http://community.csdn.net/Expert/FAQ/List_Room_FAQ_Index.asp?bigclassid=52
http://xml.sz.luohuedu.net/xml/Content.asp
http://www.developerfusion.com/utilities/convertvbtocsharp.aspx（比较的好c#到VB转换）
http://www.webasp.net/DataGrid能一次修改多行记录吗？如果不行，有其他方法实现吗？
http://community.csdn.net/Expert/topic/3110/3110415.xml?temp=.4844477DropDownList的问题,连动菜单的
http://community.csdn.net/Expert/topic/3093/3093649.xml?temp=.3064234Datagrid 显示数据库中的二进制的图片，有点难度！
http://community.csdn.net/Expert/topic/3112/3112270.xml?temp=.6695215timer 不动作？
http://community.csdn.net/Expert/topic/3114/3114792.xml?temp=.8809473asp.net打印方案（最好是操作Excel），各位高手请进！
http://community.csdn.net/Expert/topic/3114/3114640.xml?temp=.9786646在asp.net上怎么弹出保存对话框？
http://community.csdn.net/Expert/topic/2889/2889825.xml?temp=.1032984如何给密码加密呢
http://community.csdn.net/Expert/topic/3128/3128859.xml?temp=.1032984关于定时刷新客户端
http://community.csdn.net/Expert/topic/3128/3128881.xml?temp=.1032984如何让datagrid分页的按钮"上一页下一页"使用图片
http://community.csdn.net/Expert/topic/3156/3156678.xml?temp=.5541651如何获取当前的域名信息！？
http://community.csdn.net/Expert/topic/3165/3165536.xml?temp=.705166怎样根据客户中英文系统进入中英文页面?
http://community.csdn.net/Expert/topic/3169/3169965.xml?temp=.3843653怎么在文本框中屏蔽非数字的字符？
http://community.csdn.net/Expert/topic/3196/3196298.xml?temp=.6959497TextBox 的问题！
http://community.csdn.net/Expert/topic/3209/3209270.xml?temp=.7582666字符串处理的问题！
http://community.csdn.net/Expert/topic/3208/3208879.xml?temp=.9452173如果定时激活事件
http://community.csdn.net/Expert/topic/3205/3205773.xml?temp=.9452173多行的TextBox如何限制输入长度??
http://community.csdn.net/Expert/topic/2807/2807286.xml?temp=.8840143DataGrid中要加一个升序No，有没有什么好办法？
http://community.csdn.net/Expert/topic/3207/3207909.xml?temp=.5894586怎样屏蔽浏览器关闭按钮及ALT+F4 快捷键
http://community.csdn.net/Expert/topic/3209/3209562.xml?temp=.1971857将数据插到dataset中,在一起更新
http://community.csdn.net/Expert/topic/3213/3213143.xml?temp=.3740045请问如何将文件转成流存入数据库？
http://community.csdn.net/Expert/topic/3212/3212280.xml?temp=.4363214同一台机上，页面a中如何判断页面b是否打开？
http://community.csdn.net/Expert/topic/3216/3216411.xml?temp=.2874567怎样让hyperlink的文本不显示下划线？鼠标移到上面时变色、闪动、偏移的效果是怎么做出来的？
http://community.csdn.net/Expert/topic/3215/3215382.xml?temp=.3212702数据长度的问题？/
http://community.csdn.net/Expert/topic/3225/3225063.xml?temp=.3124811高手求js下拉菜单！
http://community.csdn.net/Expert/topic/3224/3224921.xml?temp=.3124811datagrid里的模板列里有个DROPDOWNLIST，但是DROPDOWNLIST里面没有commandName属性，我如何实现DROPDOWNLIST选择改变后触发DATAGRID的ITEMCOMMAND事件呢？
http://community.csdn.net/Expert/topic/3225/3225008.xml?temp=.5111505怎么的到这个月有几号
http://community.csdn.net/Expert/topic/3226/3226622.xml?temp=.550152请时间计算怎么做啊？
http://community.csdn.net/Expert/topic/3226/3226715.xml?temp=.2172663怎么web form中没有treeview控件?
http://community.csdn.net/Expert/topic/3221/3221150.xml?temp=.4811823一个关于如何读取时间里的年月日的问题(c#)
http://community.csdn.net/Expert/topic/3232/3232623.xml?temp=.3999445点“后退”时提示：警告: 网页已经过期……
http://community.csdn.net/Expert/topic/3232/3232996.xml?temp=.7035334我想在xml里建一个像数据库中的“自动递增的”ID字段，要怎么处理呢？
http://community.csdn.net/Expert/topic/3216/3216145.xml?temp=.241955求给Datagrid排序的js代码（不刷新页面）
http://community.csdn.net/Expert/topic/3240/3240019.xml?temp=.88563176个小问题
http://community.csdn.net/Expert/topic/3244/3244153.xml?temp=.6121332请问如何用asp.net如何获取网卡硬件地址？
http://community.csdn.net/Expert/topic/3245/3245524.xml?temp=.8336908
求一个形如YYYY/MM/DD的日期判断正则表达式
http://community.csdn.net/Expert/topic/3245/3245783.xml?temp=.6137201如何避免页面刷时产生的回送事件？？
http://community.csdn.net/Expert/topic/3235/3235852.xml?temp=.2632563如何让IE6.0右上角的“闭关”按钮失效？
http://community.csdn.net/Expert/topic/3246/3246351.xml?temp=.9026605求一个删掉字符串两边空格的正则表达式？
http://community.csdn.net/Expert/topic/3264/3264840.xml?temp=.6270258如何在改变datagrid行颜色的同时加上边框线效果?
http://community.csdn.net/Expert/topic/2760/2760907.xml?temp=.7303583能否启用两个以上的Forms身份验证？
http://community.csdn.net/Expert/topic/3267/3267206.xml?temp=.5668451谁知道在VB里怎样取得IP地址吗
http://community.csdn.net/Expert/topic/3278/3278237.xml?temp=.4232904请教如何判断键盘的大小写状态、数字小键盘状态？
http://community.csdn.net/Expert/topic/3275/3275147.xml?temp=.3133051如何使图片上的图片变为手型?
http://community.csdn.net/Expert/topic/3278/3278646.xml?temp=.2121088现在得到当前的路径,如:http://community.csdn.net/Expert/PostNew.asp?room=5202
我用c#在后台怎么得到:PostNew.asp这个值??
http://community.csdn.net/Expert/topic/3278/3278849.xml?temp=.4395258大侠，帮忙：ASP.net发送邮件的问题
http://community.csdn.net/Expert/topic/3268/3268007.xml?temp=.7686884怎么解决url中有汉字，该也就无法正常显示的问题？？？在线等！
http://community.csdn.net/Expert/topic/3285/3285910.xml?temp=.6879999
怎样才能彻底解决非法输入字符串的问题？
http://community.csdn.net/Expert/topic/3302/3302116.xml?temp=.1588251多文件上传带源代码
http://community.csdn.net/Expert/topic/3303/3303178.xml?temp=.3156855192.168.0.2/bb/logout.aspx 无法注销 192.168.0.1/aa下的cookie
http://community.csdn.net/Expert/topic/3215/3215703.xml?temp=.9740106ASP.net中如何实现对输入错误的提示声音？？？？（急）
http://community.csdn.net/Expert/topic/2660/2660081.xml?temp=.0885126有关您是本网站第几位访问者,各位是否有相关代码,能帮我解决么?
http://community.csdn.net/Expert/topic/3321/3321164.xml?temp=.8671533正则：密码包含字母，数字，下划线，可以，但包含*怎么验证？？
http://community.csdn.net/Expert/topic/3213/3213002.xml?temp=.5960352求asp.net好书！！！
http://community.csdn.net/Expert/topic/3321/3321571.xml?temp=.545437如何在vbscript中弹出文件保存的对话框，急~~~~~
http://community.csdn.net/Expert/topic/3322/3322899.xml?temp=.8863184net高手必看。请问如何设置ie浏览器窗口最大化？？？
http://community.csdn.net/Expert/topic/3328/3328282.xml?temp=.9729883如何不打开文件直接出现下载保存提示框
http://community.csdn.net/Expert/topic/3332/3332144.xml?temp=.9399683

调试易

100分收集DataGrid使用技巧[Asp.Net]

解决方案 »