Velocity Reviews - Computer Hardware Reviews
Home Forums Reviews Guides Newsgroups Register Search
Member Login:

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Datagrid Control > how can I get the DataKeyField

Reply
Thread Tools

how can I get the DataKeyField

 
 
Kylin
Guest
Posts: n/a
 
      04-22-2005
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">
<aspataGrid 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>
</aspataGrid>
<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:
ICQ:156134382
 
Reply With Quote
 
 
 
 
Elton W
Guest
Posts: n/a
 
      04-22-2005
Hi Kylin,


Try

datagrid.DataKeys[i]

HTH


Elton Wang



>-----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">
> <aspataGrid 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>
> </aspataGrid>
> <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:
>ICQ:156134382
>
>
>.
>
 
Reply With Quote
 
 
 
 
Kylin
Guest
Posts: n/a
 
      04-23-2005
Thanks your for your help.
I have solved this problem!



"Elton W" <> ????
news:0fe601c54737$9df85c40$...
Hi Kylin,


Try

datagrid.DataKeys[i]

HTH


Elton Wang



>-----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">
> <aspataGrid 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>
> </aspataGrid>
> <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:
>ICQ:156134382
>
>
>.
>
 
Reply With Quote
 
 
 
Reply

« Datagrid column formatting | datagrid raw »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
How to get the DataKeyField in the DataGrid ? Kylin ASP .Net Datagrid Control 1 05-31-2005 04:56 AM
Composite DataKeyField? Felbrigg ASP .Net 4 02-11-2004 07:46 AM
how to get datagrid item index from DataKeyField value? Sean ASP .Net Datagrid Control 1 08-07-2003 12:11 AM
datakeyfield and 3 fields making up the PK sramruttun ASP .Net 0 07-10-2003 06:49 AM



Advertisments
 


Powered by vBulletin®. Copyright ©2000 - 2013, vBulletin Solutions, Inc..
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57