C#GridView绑定datatable数据

GridView用法：

1.    绑定datatable

public void playtable(GridView gv, DataTable dt)

    {

        gv.DataSource = dt;

        gv.DataBind();

    }

2.    添加GridView换页，选择，排序事件（05net中以datatable为数据源时需要人工添加代码

//分页

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

    {

        GridView1.PageIndex = e.NewPageIndex;

        playtable(GridView1, eResult);//再次绑定数据

 

}

//排序

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)

    {

        ViewState["sortexpression"] = e.SortExpression;//viewstate保存排序方式

 

        if (ViewState["sortdirection"] == null)

        {

            ViewState["sortdirection"] = "asc";//默认为ascend升序

        }

        else

        {

            if (ViewState["sortdirection"].ToString() == "asc")

            {

                ViewState["sortdirection"] = "desc";

//初始为升序，点击则为descend降序

            }

            else

            {

                ViewState["sortdirection"] = "asc";

            }

        }

         gridBind(GridView1, eResult);//排序时须将datatable转dataview

}

 

 

//数据绑定须以dataview形式

    public void gridBind(GridView gv,DataTable dt)

    {

        DataView dv = dt.DefaultView;

        if (ViewState["sortexpression"] != null)

        {

            dv.Sort = ViewState["sortexpression"].ToString() + " " + ViewState["sortdirection"].ToString();

        }

 

        GridView1.DataSource = dv;

        GridView1.DataBind();

 

 

    }

//选择事件

//在选择事件中，可以写当选择该行时需要进行的操作

protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)

    {

       GridViewRow row = GridView1.SelectedRow;

         string filePath = row.Cells[1].Text.Trim().ToString();//第二列中的数据作为参数

         Session["filepath"] = filePath;

         Response.Redirect("fileDisplay.aspx");

 

 

    }