[原创]使用datagrid控件显示数据

最新推荐文章于 2023-12-13 15:32:12 发布

web718

最新推荐文章于 2023-12-13 15:32:12 发布

阅读量1.8k

点赞数

分类专栏： Asp.net开发作品文章标签： datagrid dataset asp button microsoft object

本文链接：https://blog.csdn.net/web718/article/details/389605

版权

Asp.net开发作品专栏收录该内容

32 篇文章 0 订阅

订阅专栏

在datagrid中使用了input checkbox控件。分页的效果

以下是源程序：
DataGrid1.aspx页面代码：

<%@ Page language="c#" Codebehind="DataGrid1.aspx.cs" AutoEventWireup="false" Inherits="News.DataGrid1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>DataGrid1</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 MS_POSITIONING="GridLayout">
<form runat="server">
<asp:DataGrid id="DataGrid2" runat="server" Width="100%" PageSize="5" AllowPaging="True" AutoGenerateColumns="False" AllowSorting="True">
<SelectedItemStyle Font-Bold="True" ForeColor="#CCFF99" BackColor="#009999"></SelectedItemStyle>
<HeaderStyle BackColor="#00AAAA"></HeaderStyle>
<FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle>
<Columns>
<asp:TemplateColumn HeaderText="选择">
<HeaderStyle Width="40px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<ItemTemplate>
<INPUT type=checkbox value='<%# DataBinder.Eval(Container.DataItem, "id")%>' name=checkName >
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn DataField="id" HeaderText="ID号"></asp:BoundColumn>
<asp:BoundColumn DataField="username" HeaderText="用户名"></asp:BoundColumn>
<asp:BoundColumn DataField="email" HeaderText="Email"></asp:BoundColumn>
</Columns>
<PagerStyle HorizontalAlign="Left" ForeColor="#003399" BackColor="#99CCCC" Mode="NumericPages"></PagerStyle>
</asp:DataGrid>
<P>
<asp:Label id="Label1" style="Z-INDEX: 102; LEFT: 119px; POSITION: absolute; TOP: 188px" runat="server"></asp:Label></P>
<FONT face="宋体">
<asp:Button id="Button1" style="Z-INDEX: 101; LEFT: 34px; POSITION: absolute; TOP: 187px" runat="server" Text="Button"></asp:Button></FONT>
</form>
</body>
</HTML>

.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.Configuration;
using System.Data.SqlClient;
namespace News
{
/// <summary>
/// DataGrid1 的摘要说明。
/// </summary>
public class DataGrid1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Label Label1;
string ConnectionStr=ConfigurationSettings.AppSettings["connStr"];
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
SqlConnection SconnStr=new SqlConnection(ConnectionStr);
SqlDataAdapter sda=new SqlDataAdapter("select * from user_info",SconnStr);
DataSet ds=new DataSet();
sda.Fill(ds,"user_info");
DataGrid2.DataSource=ds.Tables["user_info"].DefaultView;
DataGrid2.DataBind();
}

#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.DataGrid2.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid2_PageIndexChanged);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void Button1_Click(object sender, System.EventArgs e)
{
if(Request.Form["checkName"] != null)
{

Label1.Text = "您所选择的是：<font color=red>" + Request.Form["checkName"].ToString() +"</font>";

}
else
{
this.Label1.Text="NULL";
}

}
//分页事件,必须加入这些代码才能实现翻页的效果.
private void DataGrid2_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid2.CurrentPageIndex=e.NewPageIndex;
DataGrid2.DataBind();
}

}
}