Gridview动态绑定

 

      /// <summary>
    /// 绑定生成GridView
    /// </summary>
    /// <param name="gdv">要绑定的GridView</param>
    /// <param name="dtblDataSource">GridView的数据源</param>
    /// <param name="strDataKey">GridView的DataKeyNames</param>
    public static void GridViewBind(GridView gdv, DataTable dtblDataSource)
    {
        gdv.Columns.Clear();

        gdv.AutoGenerateColumns = false;
        gdv.DataSource = dtblDataSource;
        //gdv.DataKeyNames = new string[]{ strDataKey };
       
            
        for (int i = 0; i < dtblDataSource.Columns.Count; i++)   //绑定普通数据列
        {
            BoundField bfColumn = new BoundField();
            bfColumn.DataField = dtblDataSource.Columns[i].ColumnName;
            bfColumn.HeaderText = dtblDataSource.Columns[i].Caption;
            bfColumn.ItemStyle.BorderColor = System.Drawing.Color.Gray;
            gdv.Columns.Add(bfColumn);
           
        }
        gdv.DataBind();
    }

    protected void gvGradeLowScoreStat_RowDataBound(object sender, GridViewRowEventArgs e)
    {

        //首先判断是否是数据行
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            //当鼠标停留时更改背景色
            // e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");
            e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#C0FAFF'");
            //当鼠标移开时还原背景色
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
            switch (e.Row.Cells[1].Text.Trim())
            {
                case "1":
                   
                    e.Row.Cells[1].Text = "春季学期";
                    break;
                case "2":
                    e.Row.Cells[1].Text = "夏季学期";

                    break;
                case "3":
                   
                    e.Row.Cells[1].Text = "秋季学期";
                    break;
                case "4":

                    e.Row.Cells[1].Text = "冬季学期";
                    break;
            }
            if (flag == 0)
            {
                e.Row.Cells[0].Text = "<a  href='GradeLowScoreStatRPT1.aspx?xh=" + e.Row.Cells[0].Text + "&xm=" + Server.UrlEncode(e.Row.Cells[1].Text) + "&xn=" + hidXn.Value + "&xq=" + hidXq.Value + "&bh=" + hidBh.Value + "' style='text-decoration:underline;' target='_blank'>" + e.Row.Cells[0].Text + "</a>";
            }
            else
            {
                e.Row.Cells[2].Text = "<a  href='GradeLowScoreStatRPT2.aspx?kcbh=" + e.Row.Cells[2].Text + "&kcmc=" + Server .UrlEncode(e.Row.Cells[3].Text) + "&xn=" + hidXn.Value + "&xq=" + hidXq.Value + "&bh=" + hidBh.Value + "' style='text-decoration:underline;' target='_blank'>" + e.Row.Cells[2].Text + "</a>";
            }
            
        }
    }

--------------------------------------------------------------------



/// <summary>
    /// 绑定生成GridView
    /// </summary>
    /// <param name="gdv">要绑定的GridView</param>
    /// <param name="dtblDataSource">GridView的数据源</param>
    /// <param name="strDataKey">GridView的DataKeyNames</param>
    public static void GridViewBind(GridView gdv, DataTable dtblDataSource, string strDataKey)
   {
        gdv.Columns.Clear();

        gdv.AutoGenerateColumns = false;
        gdv.DataSource = dtblDataSource;
        gdv.DataKeyNames = new string[] { strDataKey };

        for (int i = 0; i < dtblDataSource.Columns.Count; i++)   //绑定普通数据列
       {
            BoundField bfColumn = new BoundField();
            bfColumn.DataField = dtblDataSource.Columns[i].ColumnName;
            bfColumn.HeaderText = dtblDataSource.Columns[i].Caption;
            gdv.Columns.Add(bfColumn);
        }

        gdv.Columns[1].Visible = false;

        CommandField cfModify = new CommandField();  //绑定命令列
        cfModify.ButtonType = ButtonType.Button;
        cfModify.SelectText = "修改";
        cfModify.ShowSelectButton = true;
        gdv.Columns.Add(cfModify);

        gdv.DataBind();
    }