gridview动态绑定列名和数据

来源：互联网发布：mac下载flash插件编辑：程序博客网时间：2024/05/17 03:15

protected void bind()
{
DataTable dt = getColumnField();

DataTable dt1 = getDataSource();//获得数据源

gvshow.Width = Unit.Pixel(500);

            gvshow.AutoGenerateColumns = false;

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                BoundField bc = new BoundField();
                bc.DataField = dt.Rows[i][0].ToString();
                bc.HeaderText = dt.Rows[i][1].ToString();
                gvshow.Columns.Add(bc);
            }
            this.gvshow.DataKeyNames = new string[] { "id" };
            gvshow.DataSource = dt1;
            gvshow.DataBind();

divshow.Controls.Add(gvshow);
}

public DataTable getDataSource()
{

con.Open();
string sql = "select * from dbo.sysStandardLibrary where dataobjectname='" + TreeView1.SelectedValue + "' order by id ";

            SqlDataAdapter da = new SqlDataAdapter(sql, con);
            DataSet ds = new DataSet();
            da.Fill(ds, "table");
            DataTable dt = ds.Tables["table"];
            con.Close();
            return dt;

        }
        public DataTable getColumnField()
        {

con.Open();
string sql = "select fieldname,fieldchname from display_columnname where dataobjectname='" + TreeView1.SelectedValue + "' order by id ";

            SqlDataAdapter da = new SqlDataAdapter(sql, con);
            DataSet ds = new DataSet();
            da.Fill(ds, "table");
            DataTable dt = ds.Tables["table"];
            con.Close();
            return dt;
        }