Compdigitec Labs

« | Home | »

ASP.NET GridView All-In-One Quick Reference

By admin | July 17, 2010

Here is a quick collection of snippets where one can quickly lookup the necessities of setting up a GridView for the purposes of displaying information to the viewer through a database (for example, MySQL):

Adding Columns of Data

DataTable dt = new DataTable("Tablename");
dt.Columns.Add("Column1");
dt.Columns.Add("Column2");
dt.Columns.Add("Column3");
// for every row
DataRow dr = dt.NewRow();
dr["Column1"] = "Testing";
dr["Column2"] = "Blah";
dr["Column3"] = "Big Blah";
dt.Rows.Add(dr);

Binding the Data (and storage across sessions)

DataView dv = new DataView(dt);
Session["data"] = dv;
gridviewctrl.DataSource = dv;
gridviewctrl.DataBind();

Paging
Note: This needs AllowPaging to be set to “true”. The following code goes in the “PageIndexChanging” callback.

gridviewctrl.PageIndex = e.NewPageIndex;
gridviewctrl.DataSource = Session["data"];
gridviewctrl.DataBind();

Sorting
Note: This needs AllowSorting to be set to “true” and ensure all columns you want sorted have a “SortExpression” that matches the column name in the DataTable. The following code goes in the “Sorting” callback.

string dir;
if (e.SortDirection == SortDirection.Ascending) {
    dir = "ASC";
} else {
    dir = "DESC";
}
((DataView)Session["Data"]).Sort = e.SortExpression + " " + dir;
gridviewctrl.DataSource = Session["data"];
gridviewctrl.DataBind();

<asp:ButtonField>s
Create a <asp:ButtonField> declaration as follows: <asp:ButtonField ButtonType=”Button” Text=”Button Text Here” CommandName=”DoSomething” />

if (e.CommandName == "DoSomething") {
    // get Index
    int index = Convert.ToInt32(e.CommandArgument);
    string test = ((DataView)Session["Data"]).Table.Rows[index]["Column1"];
    Response.Redirect("http://www.google.com/search?q=" + test.ToString()");
}

If you found this article helpful or interesting, please help Compdigitec spread the word. Don’t forget to subscribe to Compdigitec Labs for more useful and interesting articles!

Topics: Internet, Windows | 10 Comments »

10 Responses to “ASP.NET GridView All-In-One Quick Reference”

  1. เว็บสล็อต แตกหนัก รวมเกมทุกค่าย วางใจได้100% Says:
    January 18th, 2025 at 16:35

    … [Trackback]

    […] Information to that Topic: compdigitec.com/labs/2010/07/17/asp-net-gridview-all-in-one-quick-reference/ […]

  2. hit789 Says:
    January 25th, 2025 at 12:08

    … [Trackback]

    […] Read More on on that Topic: compdigitec.com/labs/2010/07/17/asp-net-gridview-all-in-one-quick-reference/ […]

  3. เจ้ามือ หวยใต้ดิน Says:
    January 25th, 2025 at 18:24

    … [Trackback]

    […] Info on that Topic: compdigitec.com/labs/2010/07/17/asp-net-gridview-all-in-one-quick-reference/ […]

  4. best gym equipment shop online Says:
    February 3rd, 2025 at 06:38

    … [Trackback]

    […] Find More on that Topic: compdigitec.com/labs/2010/07/17/asp-net-gridview-all-in-one-quick-reference/ […]

  5. Aviator game Says:
    March 10th, 2025 at 16:03

    … [Trackback]

    […] Find More to that Topic: compdigitec.com/labs/2010/07/17/asp-net-gridview-all-in-one-quick-reference/ […]

  6. เช่าเครื่องเสียง Says:
    March 11th, 2025 at 23:05

    … [Trackback]

    […] Read More Info here on that Topic: compdigitec.com/labs/2010/07/17/asp-net-gridview-all-in-one-quick-reference/ […]

  7. ezybet88 Says:
    March 12th, 2025 at 20:33

    … [Trackback]

    […] Find More here to that Topic: compdigitec.com/labs/2010/07/17/asp-net-gridview-all-in-one-quick-reference/ […]

  8. lotto888 Says:
    March 13th, 2025 at 03:35

    … [Trackback]

    […] Read More on on that Topic: compdigitec.com/labs/2010/07/17/asp-net-gridview-all-in-one-quick-reference/ […]

  9. ซื้อหวยออนไลน์ 24 ชม. รวยเน้นๆ ปลอดภัย Says:
    March 15th, 2025 at 07:00

    … [Trackback]

    […] Find More on to that Topic: compdigitec.com/labs/2010/07/17/asp-net-gridview-all-in-one-quick-reference/ […]

  10. สับปะรด สล็อต ฝากถอนออโต้ ทรูวอเลท Says:
    March 15th, 2025 at 23:25

    … [Trackback]

    […] Info to that Topic: compdigitec.com/labs/2010/07/17/asp-net-gridview-all-in-one-quick-reference/ […]

Comments