ASP.NET GridView examples – Using code-behind – no wizards – no drag/drop

asp.netgridview

I am looking to implement and learn more about the ASP.NET GridView control. However, all the examples I have found seem to focus on setting up a SQL Datasource within the ASPX page. I prefer to keep markup as seperate as possible from code and therefore all datasource binding I like to do in the code-behind. So it would be great to see an example that setup the GridView in that manner.

Also, most of the examples, I have seen, step through using the Visual Studio IDE and wizards to implement the GridView. I would like to see how it is done from a pure code point of view.

Does anyone have any examples or perhaps know of some resources that describes usage of the GridView control in the manner in which I described?

It would be great to see an example(s) that cover sorting, paging, and CRUD operations. Thanks for your time.

Best Answer

A simple example that includes sorting and paging. Gridview Example. Obviously you just need to plug in your call to your DAL and put the data in a DataTable. Though the example is simplistic, I think it conveys what is needed to get rolling.

Related Solutions

Using Gridview in aspx.vb (code-behind)

vb code:

Dim mydatatable As New DataTable
' Create columns
mydatatable.Columns.Add("field_a", Type.GetType("System.String"))
mydatatable.Columns.Add("field_b", Type.GetType("System.String"))
' Declare row
Dim myrow As DataRow
' create new row
myrow = mydatatable.NewRow
myrow("field_a") = "filed a row 1"
myrow("field_b") = "filed b row 1"
mydatatable.Rows.Add(myrow)

GridView1.datasource = mydatatable
gridview1.databind()

aspx code:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true" EmptyDataText="if im not at my desk im at the balcony contemplating suicide" >
<Columns></Columns>
</asp:GridView>

R – Is the ASP.net GridView control a clever design

If you are trying to make a basic CRUD website, have a look at ASP.NET 3.5 Dynamic Data which is a great website to add as a pure data access website with CRUD ability. However, its extremely customizable.

Gridview has its advantages and I used to love it in the .Net 2.0 times about two/three years ago. However, since then there are much better .Net 3.5 controls (like ListView) that give you a better ability to customize content. I'd also have a look at many third party grid tools from (Telerik, Infragistics, ComponentArt, ComponentOne, DevExpress) that have a lot more capability than the inbuilt gridview control.

Best Answer

Related Solutions

Using Gridview in aspx.vb (code-behind)

R – Is the ASP.net GridView control a clever design

Related Topic