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):<\/p>\n
Adding Columns of Data<\/strong><\/p>\n Binding the Data (and storage across sessions)<\/strong><\/p>\n Paging<\/strong> Sorting<\/strong> <asp:ButtonField>s<\/strong> 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 Binding the Data (and storage across sessions) Paging Note: This needs AllowPaging to be set to “true”. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14,4],"tags":[681,680,289,697,700,696,689,698,699],"_links":{"self":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts\/178"}],"collection":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/comments?post=178"}],"version-history":[{"count":0,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts\/178\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/media?parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/categories?post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/tags?post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\r\nDataTable dt = new DataTable("Tablename");\r\ndt.Columns.Add("Column1");\r\ndt.Columns.Add("Column2");\r\ndt.Columns.Add("Column3");\r\n\/\/ for every row\r\nDataRow dr = dt.NewRow();\r\ndr["Column1"] = "Testing";\r\ndr["Column2"] = "Blah";\r\ndr["Column3"] = "Big Blah";\r\ndt.Rows.Add(dr);\r\n<\/pre>\n\r\nDataView dv = new DataView(dt);\r\nSession["data"] = dv;\r\ngridviewctrl.DataSource = dv;\r\ngridviewctrl.DataBind();\r\n<\/pre>\n
\nNote: This needs AllowPaging to be set to “true”. The following code goes in the “PageIndexChanging” callback.<\/p>\n\r\ngridviewctrl.PageIndex = e.NewPageIndex;\r\ngridviewctrl.DataSource = Session["data"];\r\ngridviewctrl.DataBind();\r\n<\/pre>\n
\nNote: 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.<\/p>\n\r\nstring dir;\r\nif (e.SortDirection == SortDirection.Ascending) {\r\n dir = "ASC";\r\n} else {\r\n dir = "DESC";\r\n}\r\n((DataView)Session["Data"]).Sort = e.SortExpression + " " + dir;\r\ngridviewctrl.DataSource = Session["data"];\r\ngridviewctrl.DataBind();\r\n<\/pre>\n
\nCreate a <asp:ButtonField> declaration as follows: <asp:ButtonField ButtonType=”Button” Text=”Button Text Here” CommandName=”DoSomething” \/><\/p>\n\r\nif (e.CommandName == "DoSomething") {\r\n \/\/ get Index\r\n int index = Convert.ToInt32(e.CommandArgument);\r\n string test = ((DataView)Session["Data"]).Table.Rows[index]["Column1"];\r\n Response.Redirect("http:\/\/www.google.com\/search?q=" + test.ToString()");\r\n}\r\n<\/pre>","protected":false},"excerpt":{"rendered":"