Home All Groups Group Topic Archive Search About

how can I get the DataKeyField

microsoft.public.dotnet.framework.aspnet.datagridcontrol
Author
22 Apr 2005 11:44 AM
Kylin
All that I want to get the DataKeyFielD
this is the under code

Response.Write(DataGrid1.DataKeyField[i].ToString());


but the result is no I want ..


<!-- html.. -->
<%@ Page language="c#" Codebehind="DG_DataKeyFied.aspx.cs"
AutoEventWireup="false" Inherits="ForTest.DG_DataKeyFied" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
  <title>DG_DataKeyFied</title>
  <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
  <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>
  <form id="Form1" method="post" runat="server">
   <asp:DataGrid id="DataGrid1" runat="server" Width="100%"
DataKeyField="au_id">
    <Columns>
     <asp:TemplateColumn>
      <ItemTemplate>
       <asp:CheckBox ID="remove" Runat="server"></asp:CheckBox>
      </ItemTemplate>
     </asp:TemplateColumn>
    </Columns>
   </asp:DataGrid>
   <asp:Button id="btnGet" runat="server" Text="Get the Value of the checked
Item !"></asp:Button>
  </form>
</body>
</HTML>

//Behind.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 ForTest
{
/// <summary>
/// DG_DataKeyFied µÄժҪ˵Ã÷¡£
/// </summary>
public class DG_DataKeyFied : System.Web.UI.Page
{
  protected System.Web.UI.WebControls.DataGrid DataGrid1;
  private SqlConnection myConn;
  private SqlCommand myComm;
  protected System.Web.UI.WebControls.Button btnGet;
  private SqlDataAdapter myAdapter;

  private void Page_Load(object sender, System.EventArgs e)
  {
   // ÔÚ´Ë´¦·ÅÖÃÓû§´úÂëÒÔ³õʼ»¯Ò³Ãæ
   if(!this.IsPostBack)
   {
    DGBind();
   }


  }

  private void DGBind()
  {
   DataSet data=new DataSet();
   myConn=new SqlConnection("server=127.0.0.1;user
id=sa;pwd=sa;database=pubs");
   myComm=new SqlCommand("Select * From authors",myConn);
   myAdapter=new SqlDataAdapter();
   myAdapter.SelectCommand=myComm;
   myAdapter.Fill(data);
   DataGrid1.DataSource=data;
   DataGrid1.DataBind();
  }

  #region Web ´°ÌåÉè¼ÆÆ÷Éú³ÉµÄ´úÂë
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: ¸Ãµ÷ÓÃÊÇ ASP.NET Web ´°ÌåÉè¼ÆÆ÷Ëù±ØÐèµÄ¡£
   //
   InitializeComponent();
   base.OnInit(e);
  }

  /// <summary>
  /// Éè¼ÆÆ÷Ö§³ÖËùÐèµÄ·½·¨ - ²»ÒªÊ¹ÓôúÂë±à¼­Æ÷ÐÞ¸Ä
  /// ´Ë·½·¨µÄÄÚÈÝ¡£
  /// </summary>
  private void InitializeComponent()
  {
   this.btnGet.Click += new System.EventHandler(this.btnGet_Click);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion

  private void btnGet_Click(object sender, System.EventArgs e)
  {
   int id;
   for(int i=0;i<DataGrid1.Items.Count;i++)
   {
    CheckBox remove=(CheckBox)DataGrid1.Items[i].FindControl("remove");

    if (remove.Checked==true)
    {

     Response.Write(DataGrid1.DataKeyField[i].ToString());


    }
   }

  }
}
}





--
FireCrow Studio
Kylin Garden
EMail:w***@sohu.com
ICQ:156134382

Author
22 Apr 2005 12:34 PM
Elton W
Hi Kylin,


Try

datagrid.DataKeys[i]

HTH


Elton Wang
elton_w***@hotmail.com


Show quoteHide quote
>-----Original Message-----
>All that I want to get the DataKeyFielD
>this is the under code
>
>Response.Write(DataGrid1.DataKeyField[i].ToString());
>
>
>but the result is no I want ..
>
>
><!-- html.. -->
><%@ Page language="c#" Codebehind="DG_DataKeyFied.aspx.cs"
>AutoEventWireup="false" Inherits="ForTest.DG_DataKeyFied"
%>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN" >
><HTML>
> <HEAD>
>  <title>DG_DataKeyFied</title>
>  <meta name="GENERATOR" Content="Microsoft Visual
Studio .NET 7.1">
>  <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>
>  <form id="Form1" method="post" runat="server">
>   <asp:DataGrid id="DataGrid1" runat="server"
Width="100%"
>DataKeyField="au_id">
>    <Columns>
>     <asp:TemplateColumn>
>      <ItemTemplate>
>       <asp:CheckBox ID="remove"
Runat="server"></asp:CheckBox>
>      </ItemTemplate>
>     </asp:TemplateColumn>
>    </Columns>
>   </asp:DataGrid>
>   <asp:Button id="btnGet" runat="server" Text="Get the
Value of the checked
Show quoteHide quote
>Item !"></asp:Button>
>  </form>
> </body>
></HTML>
>
>//Behind.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 ForTest
>{
> /// <summary>
> /// DG_DataKeyFied µÄժҪ˵Ã÷¡£
> /// </summary>
> public class DG_DataKeyFied : System.Web.UI.Page
> {
>  protected System.Web.UI.WebControls.DataGrid DataGrid1;
>  private SqlConnection myConn;
>  private SqlCommand myComm;
>  protected System.Web.UI.WebControls.Button btnGet;
>  private SqlDataAdapter myAdapter;
>
>  private void Page_Load(object sender, System.EventArgs
e)
>  {
>   // ÔÚ´Ë´¦·ÅÖÃÓû§´úÂëÒÔ³õʼ»¯Ò³Ãæ
>   if(!this.IsPostBack)
>   {
>    DGBind();
>   }
>
>
>  }
>
>  private void DGBind()
>  {
>   DataSet data=new DataSet();
>   myConn=new SqlConnection("server=127.0.0.1;user
>id=sa;pwd=sa;database=pubs");
>   myComm=new SqlCommand("Select * From authors",myConn);
>   myAdapter=new SqlDataAdapter();
>   myAdapter.SelectCommand=myComm;
>   myAdapter.Fill(data);
>   DataGrid1.DataSource=data;
>   DataGrid1.DataBind();
>  }
>
>  #region Web ´°ÌåÉè¼ÆÆ÷Éú³ÉµÄ´úÂë
>  override protected void OnInit(EventArgs e)
>  {
>   //
>   // CODEGEN: ¸Ãµ÷ÓÃÊÇ ASP.NET Web ´°ÌåÉè¼ÆÆ÷Ëù±ØÐèµÄ¡£
>   //
>   InitializeComponent();
>   base.OnInit(e);
>  }
>
>  /// <summary>
>  /// Éè¼ÆÆ÷Ö§³ÖËùÐèµÄ·½·¨ - ²»ÒªÊ¹ÓôúÂë±à¼­Æ÷ÐÞ¸Ä
>  /// ´Ë·½·¨µÄÄÚÈÝ¡£
>  /// </summary>
>  private void InitializeComponent()
>  {
>   this.btnGet.Click += new System.EventHandler
(this.btnGet_Click);
>   this.Load += new System.EventHandler(this.Page_Load);
>
>  }
>  #endregion
>
>  private void btnGet_Click(object sender,
System.EventArgs e)
>  {
>   int id;
>   for(int i=0;i<DataGrid1.Items.Count;i++)
>   {
>    CheckBox remove=(CheckBox)DataGrid1.Items
[i].FindControl("remove");
Show quoteHide quote
>
>    if (remove.Checked==true)
>    {
>
>     Response.Write(DataGrid1.DataKeyField[i].ToString());
>
>
>    }
>   }
>
>  }
> }
>}
>
>
>
>
>
>--
>FireCrow Studio
>Kylin Garden
>EMail:w***@sohu.com
>ICQ:156134382
>
>
>.
>
Author
23 Apr 2005 1:37 AM
Kylin
Thanks your for your help.
I have solved this problem!



"Elton W" <anonym***@discussions.microsoft.com> ????
news:0fe601c54737$9df85c40$a401280a@phx.gbl...
Hi Kylin,


Try

datagrid.DataKeys[i]

HTH


Elton Wang
elton_w***@hotmail.com


Show quoteHide quote
>-----Original Message-----
>All that I want to get the DataKeyFielD
>this is the under code
>
>Response.Write(DataGrid1.DataKeyField[i].ToString());
>
>
>but the result is no I want ..
>
>
><!-- html.. -->
><%@ Page language="c#" Codebehind="DG_DataKeyFied.aspx.cs"
>AutoEventWireup="false" Inherits="ForTest.DG_DataKeyFied"
%>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN" >
><HTML>
> <HEAD>
>  <title>DG_DataKeyFied</title>
>  <meta name="GENERATOR" Content="Microsoft Visual
Studio .NET 7.1">
>  <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>
>  <form id="Form1" method="post" runat="server">
>   <asp:DataGrid id="DataGrid1" runat="server"
Width="100%"
>DataKeyField="au_id">
>    <Columns>
>     <asp:TemplateColumn>
>      <ItemTemplate>
>       <asp:CheckBox ID="remove"
Runat="server"></asp:CheckBox>
>      </ItemTemplate>
>     </asp:TemplateColumn>
>    </Columns>
>   </asp:DataGrid>
>   <asp:Button id="btnGet" runat="server" Text="Get the
Value of the checked
Show quoteHide quote
>Item !"></asp:Button>
>  </form>
> </body>
></HTML>
>
>//Behind.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 ForTest
>{
> /// <summary>
> /// DG_DataKeyFied µÄժҪ˵Ã÷¡£
> /// </summary>
> public class DG_DataKeyFied : System.Web.UI.Page
> {
>  protected System.Web.UI.WebControls.DataGrid DataGrid1;
>  private SqlConnection myConn;
>  private SqlCommand myComm;
>  protected System.Web.UI.WebControls.Button btnGet;
>  private SqlDataAdapter myAdapter;
>
>  private void Page_Load(object sender, System.EventArgs
e)
>  {
>   // ÔÚ´Ë´¦·ÅÖÃÓû§´úÂëÒÔ³õʼ»¯Ò³Ãæ
>   if(!this.IsPostBack)
>   {
>    DGBind();
>   }
>
>
>  }
>
>  private void DGBind()
>  {
>   DataSet data=new DataSet();
>   myConn=new SqlConnection("server=127.0.0.1;user
>id=sa;pwd=sa;database=pubs");
>   myComm=new SqlCommand("Select * From authors",myConn);
>   myAdapter=new SqlDataAdapter();
>   myAdapter.SelectCommand=myComm;
>   myAdapter.Fill(data);
>   DataGrid1.DataSource=data;
>   DataGrid1.DataBind();
>  }
>
>  #region Web ´°ÌåÉè¼ÆÆ÷Éú³ÉµÄ´úÂë
>  override protected void OnInit(EventArgs e)
>  {
>   //
>   // CODEGEN: ¸Ãµ÷ÓÃÊÇ ASP.NET Web ´°ÌåÉè¼ÆÆ÷Ëù±ØÐèµÄ¡£
>   //
>   InitializeComponent();
>   base.OnInit(e);
>  }
>
>  /// <summary>
>  /// Éè¼ÆÆ÷Ö§³ÖËùÐèµÄ·½·¨ - ²»ÒªÊ¹ÓôúÂë±à¼­Æ÷ÐÞ¸Ä
>  /// ´Ë·½·¨µÄÄÚÈÝ¡£
>  /// </summary>
>  private void InitializeComponent()
>  {
>   this.btnGet.Click += new System.EventHandler
(this.btnGet_Click);
>   this.Load += new System.EventHandler(this.Page_Load);
>
>  }
>  #endregion
>
>  private void btnGet_Click(object sender,
System.EventArgs e)
>  {
>   int id;
>   for(int i=0;i<DataGrid1.Items.Count;i++)
>   {
>    CheckBox remove=(CheckBox)DataGrid1.Items
[i].FindControl("remove");
Show quoteHide quote
>
>    if (remove.Checked==true)
>    {
>
>     Response.Write(DataGrid1.DataKeyField[i].ToString());
>
>
>    }
>   }
>
>  }
> }
>}
>
>
>
>
>
>--
>FireCrow Studio
>Kylin Garden
>EMail:w***@sohu.com
>ICQ:156134382
>
>
>.
>



Post Other interesting topics
Paging with Datagrid Control
Howto insert delete rows into a ASP.net datagrid?
read row values from datagrid and populate in new datagrid values from connected
MessageBox not showing before Response.Redirect
ItemDataBound
Accessing data object on delete command.
Datagrid paging keeps going back to the first group
filtering from multiple dropdownlists
Slow datagrid on postback
how to use hyper columns in datagrid