最近实习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;
                }
            }
        }
    }
}

以上就是全部代码,并且测试成功,不过个人还是觉得代码有点繁琐,效率或许还有所欠缺.
如有高人偶路过此地,请指教,提出您的建议. 谢谢