最近实习ing...正好做到关于GridView的页面,不过用的控件是ComponentArt,这个是用Ajax技术做的,不过原理差不多吧.
然后有空的时候研究了下GridView,做了个例子.对于各位高人来说比较简单吧.
数据库用的是NorthWind,表是Categories,然后自己相应的又建立了个SetCategories
Create Table SetCategories
(
ID int identity(1,1) Primary Key,
Account nvarchar(15),
ColumnName nvarchar(15),
IsDisplay tinyint
)
IsDisplay的值为0或者1,1则显示Categories表中相应的该列,0则不显示.然后通过Account根据不同用户来相应的显示
测试数据:
Insert Into SetCategories('123','编号',1);
Insert Into SetCategories('123','名称',1);
Insert Into SetCategories('123','描述',0);
Insert Into SetCategories('456','编号',0);
Insert Into SetCategories('456','名称',0);
Insert Into SetCategories('456','描述',1);
Insert Into SetCategories('789','编号',1);
Insert Into SetCategories('789','名称',1);
Insert Into SetCategories('789','描述',1);
代码如下:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="GridViewTest._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="dv" runat="server" AutoGenerateColumns="false" OnRowDataBound="dv_RowDataBound">
<Columns>
<asp:BoundField DataField="CategoryID" HeaderText="编号" />
<asp:BoundField DataField="CategoryName" HeaderText="名称" />
<asp:BoundField DataField="Description" HeaderText="描述" />
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
CS文件
/********************************************************************
* Author:Sai
* Date:2007/1/29
* Function:定制GridView
*
* ****************************************************************/
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace GridViewTest
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
BindDate();
}
/// <summary>
/// 显示当前所有的信息
/// </summary>
public void BindDate()
{
SqlConnection conn = new SqlConnection("server=(local);database=NorthWind;pwd=pass;user id=sa");
conn.Open();
DataSet ds1 = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("Select * From Categories", conn);
da.Fill(ds1);
dv.DataSource = ds1;
dv.DataBind();
}
protected void dv_RowDataBound(object sender, GridViewRowEventArgs e)
{
SqlConnection conn = new SqlConnection("server=(local);database=NorthWind;pwd=pass;user id=sa");
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("Select * From SetCategories Where Account = '789'", conn);
da.Fill(ds);
for (int i = 0; i <= ds.Tables[0].Rows.Count-1;i++)
{
if((byte)ds.Tables[0].Rows[i]["IsDisplay"] == 0)
{
e.Row.Cells[i].Visible = false;
}
}
}
}
}
以上就是全部代码,并且测试成功,不过个人还是觉得代码有点繁琐,效率或许还有所欠缺.
如有高人偶路过此地,请指教,提出您的建议. 谢谢
浙公网安备 33010602011771号