读书人

怎么取出datagrid中的记录

发布时间: 2012-01-30 21:15:58 作者: rapoo

如何取出datagrid中的记录
在WebForm 中鼠标单击DtatGrid中的一条记录,如何把它取出来?最好能有个小例子参考一下~谢谢 !!~~

[解决办法]
用e.Item.ItemIndex参数
[解决办法]
用SelectedIndexChanged事件
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
Label0.Text=this.DataGrid1.SelectedItem.Cells[0].Text;
Label1.Text=this.DataGrid1.SelectedItem.Cells[1].Text;
...........
}
[解决办法]
列表页
<HTML>
<HEAD>
<title> WebForm5 </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>


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 testWebSite
{
/// <summary>
/// WebForm5 的摘要说明。
/// </summary>
public class WebForm5 : System.Web.UI.Page
{
string PageID;

protected System.Web.UI.WebControls.DataGrid DGPageNew;

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
DB db = new DB();

String Sql = "select ID,title from testweb order by id desc ";

db.SetDataBinding(this.DGPageNew,Sql);

db.CloseDataBase();
}

#region Web 窗体设计器生成的代码
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
}
}


详细信息页
<HTML>
<HEAD>
<title> WebForm6 </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 MS_POSITIONING= "GridLayout ">
<form id= "Form1 " method= "post " runat= "server ">
<FONT face= "宋体 ">
<div>
<asp:DataGrid ID= "dgXX " Runat= "server " AutoGenerateColumns= "false ">
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<table>
<tr>
<td> 标题: </td>
<td> <%# DataBinder.Eval(Container.DataItem, "Title ")%> </td>


</tr>
<tr>
<td> 内容: </td>
<td> <%# DataBinder.Eval(Container.DataItem, "Content ")%> </td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</div>
</FONT>
</form>
</body>
</HTML>


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;

namespace testWebSite
{
/// <summary>
/// WebForm6 的摘要说明。
/// </summary>
public class WebForm6 : System.Web.UI.Page
{
string PageID;
protected System.Web.UI.WebControls.DataGrid dgXX;

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
DB db = new DB();

//if(!Page.IsPostBack)
PageID = Request.QueryString[ "ID "].ToString();
string Sql = "select * from testweb where id= ' "+PageID+ " ' ";

db.SetDataBinding(this.dgXX,Sql);

db.CloseDataBase();


}

#region Web 窗体设计器生成的代码
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
}
}
<body MS_POSITIONING= "GridLayout ">
<form id= "Form1 " method= "post " runat= "server ">
<FONT face= "宋体 ">
<div align= "center ">
<asp:DataGrid ID= "DGPageNew " Runat= "server " AutoGenerateColumns= "false " HeaderStyle-BackColor= "Lavender " BorderWidth= "1 ">
<Columns>
<asp:BoundColumn HeaderText= "ID " DataField= "id " HeaderStyle-Width= "30 " HeaderStyle-HorizontalAlign= "Center "> </asp:BoundColumn>
<asp:TemplateColumn HeaderText= "标题 " ItemStyle-BackColor= "AliceBlue ">
<ItemTemplate>
<table align= "center " width= "300 ">
<tr>
<td>    <a href= "WebForm6.aspx?id= <%# DataBinder.Eval(Container.DataItem, "id ")%> "> <%# DataBinder.Eval(Container.DataItem, "title ")%> </a>
</td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</div>
</FONT>
</form>
</body>
</HTML>

读书人网 >asp.net

热点推荐