how can I get the DataKeyField

K

Kylin

All that I want to get the DataKeyFielD
this is the under code

Response.Write(DataGrid1.DataKeyField.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.FindControl("remove");

if (remove.Checked==true)
{

Response.Write(DataGrid1.DataKeyField.ToString());


}
}

}
}
}
 
E

Elton W

Hi Kylin,


Try

datagrid.DataKeys

HTH


Elton Wang
(e-mail address removed)

-----Original Message-----
All that I want to get the DataKeyFielD
this is the under code

Response.Write(DataGrid1.DataKeyField.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"
Click to expand...

Runat="server"> said:
</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 .FindControl("remove");

if (remove.Checked==true)
{

Response.Write(DataGrid1.DataKeyField.ToString());


}
}

}
}
}





--
FireCrow Studio
Kylin Garden
EMail:[email protected]
ICQ:156134382


.
Click to expand...
 
K

Kylin

Thanks your for your help.
I have solved this problem!



"Elton W" <[email protected]> ????
Hi Kylin,


Try

datagrid.DataKeys

HTH


Elton Wang
(e-mail address removed)

-----Original Message-----
All that I want to get the DataKeyFielD
this is the under code

Response.Write(DataGrid1.DataKeyField.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"
Click to expand...

Runat="server"> said:
</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 .FindControl("remove");

if (remove.Checked==true)
{

Response.Write(DataGrid1.DataKeyField.ToString());


}
}

}
}
}





--
FireCrow Studio
Kylin Garden
EMail:[email protected]
ICQ:156134382


.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can i fix Mysql images not found error? 0
CSS: How can I stop overflow on the y-axis? 2
Datagrid PageIndexChanged event doesn't fire 1
DataKeyField causes DataBinder.Eval error 0
how to add checkbox to a datagrid? 1
How do I save information from an GUI into a XML-file? 0
How Do I Use a CheckBox to Update a Bit Type Data Field in a DataGrid 0
Edit DataGrid Dropdown cell 2

Members online

Total: 24 (members: 1, guests: 23)
Robots: 215

Forum statistics

Threads
473,764
Messages
2,569,567
Members
45,041
Latest member
RomeoFarnh

Latest Threads

Top