How to work with SPGridView using Object Data Source.

To work with SPGridview you need to register
 <%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

Now we can start working with SPGridView. First will add SPGridView control on our aspx page.

<SharePoint:SPGridView runat="server" ID="SPGridView1"
 AutoGenerateColums="false"  PageSize="300" AllowPaging="true" AllowFiltering="true"
 AllowSorting="true"   AutoGenerateColumns="false"> </SharePoint:SPGridView>

<SharePoint:SPGridViewPager ID="SPGridViewPager1" runat="server" GridViewId="SPGridView1"></SharePoint:SPGridViewPager>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" />

You can see that I have added three control SPgridView, SPGridViewPager, and ObjectDatasource.
Mostly ppl don’t use objectdatasource in context of SPGridview but there may be a scenario that you need to use custom data source. Let me explain some part for you , suppose u need to get all items from Sharepoint list and then u alter some field and then need to show in spridview in this situation filtering and sorting will not work automatic and u will suffer lots, so in that situation we need to use this ObjectDataSource.
Now you need to write code on your vb file.
First we need to write code either on page load or CreateChildControls event. I am going to write on CreateChildControls so no need to handle postback.

Protected Overrides Sub CreateChildControls()
        Dim obj As New Foobar()
        ObjectDataSource1.TypeName = obj.GetType().AssemblyQualifiedName
        BuildGridColumns()
        ObjectDataSource1.SelectMethod = "getall"
        Me.SPGridView1.DataSourceID = "ObjectDataSource1"
        Me.SPGridView1.DataBind()
End Sub

In this i have create one object of Foobar class so we can give ObjectDataSource TypeName.
Next line for assigning TypeName of object. That means which type of data this ObjectDataSource going to store, since we are going to store Foobar type so I am assigning foobar assembly Qualified name.
Now next line is for creating columns in SPGRidview. So I have created one function that will create columns in SPGRidview.

Private Sub BuildGridColumns()
        Me.SPGridView1.Columns.Clear()
        Dim gridColumn3 As New SPBoundField With { _
           .DataField = "SNo", _
                           .HeaderText = "S/No", _
                           .SortExpression = "SNo" _
                       }
        Me.SPGridView1.Columns.Add(gridColumn3)
        Dim gridColumn4a As New SPBoundField With { _
                           .DataField = "Title", _
                           .HeaderText = "File Ref No", _
                           .SortExpression = "Title" _
                       }
        Me.SPGridView1.Columns.Add(gridColumn4a)
        Me.SPGridView1.FilterDataFields = "SNo,Title"
        Me.SPGridView1.FilteredDataSourcePropertyName = "FilterExpression"
        Me.SPGridView1.FilteredDataSourcePropertyFormat = "{1} Like'{0}'"
    End Sub

Now this function is creating two columns, and then adding to SPGridView.
 After that assigning Filter Data Fields so that filtering can be done. For that simply assigning 3 properties FilterDataFields, FilteredDataSourcePropertyName, .FilteredDataSourcePropertyFormat.
Note:-Here no need to change anything in your code for filtering just need to give same value and it will work(Last 2 line).
Come back to CreateChildControls sub. Next line is SelectMethod=”getalll”. Fon now i am skiping this , will explain after explaing few more things
.
Next line is assigning DatasourceId of SPGirdview. For this putting objcetDatasource id as string.
After that we bind SPGridview to data source.
Now come to the “getall” this is a function of foobar class. Function will return datasource as Datatable. Now check our class Foobar.

Public Class Foobar
    Private _SNo As String
    Public Property SNo() As String
        Get
            Return _SNo
        End Get
        Set(ByVal value As String)
            _SNo = value
        End Set
    End Property
    Private _Title As String
    Public Property Title() As String
        Get
            Return _Title
        End Get
        Set(ByVal value As String)
            _Title = value
        End Set
    End Property
    Public Function getall() As DataTable
        Dim _site As SPSite = SPContext.Current.Site
        Dim result As New System.Collections.Generic.List(Of Foobar)
        Using _web As SPWeb = _site.OpenWeb("")
            Dim _list As SPList = _web.Lists("")
            Dim spList As SPListItemCollection = _list.Items
            For Each _it In spList
                Dim _new As New Foobar
                _new.SNo = _it("ID")
                _new.Title = _it("Title")
                result.Add(_new)
            Next
        End Using
        Dim datatable As DataTable = BuildDataTable(Of Foobar)(result)
        Dim ListAsDataView As DataView = datatable.DefaultView
        Return datatable
    End Function
 Public Function BuildDataTable(Of T)(ByVal lst As System.Collections.Generic.List(Of T)) As DataTable
        'create DataTable Structure
        Dim tbl As DataTable = CreateTable(Of T)()
        Dim entType As Type = GetType(T)
        Dim properties As PropertyDescriptorCollection = TypeDescriptor.GetProperties(entType)
        'get the list item and add into the list
        For Each item As T In lst
            Dim row As DataRow = tbl.NewRow()
            For Each prop As PropertyDescriptor In properties
                row(prop.Name) = prop.GetValue(item)
            Next
            tbl.Rows.Add(row)
        Next
        Return tbl
    End Function
    Private Function CreateTable(Of T)() As DataTable
        'T –> ClassName
        Dim entType As Type = GetType(T)
        'set the datatable name as class name
        Dim tbl As New DataTable(entType.Name)
        'get the property list
        Dim properties As PropertyDescriptorCollection = TypeDescriptor.GetProperties(entType)
        For Each prop As PropertyDescriptor In properties
            'add property as column
            tbl.Columns.Add(prop.Name, prop.PropertyType)
        Next
        Return tbl
    End Function

If you will go through this class you will find there are 3 functions and two properties you can add as much as property you want. “getall” function is responsible for fetching data from SharePoint list and assigning to Foobar class.

After that inside “getall” we are calling BuildDataTable() function. In this function we are passing list collection(result) of Foobar and Type of list that is Foobar (Dim datatable As DataTable = BuildDataTable(Of Foobar)(result))
In this function you can see that we are calling one other function(CreateTable) that create columns for Table. Once table and columns has created we can assign value to each columns.
After that will have one table that will keep information of one list.
Why we are using table and why we are sending all data inform of table?
If you are not able to find this answer post here I will try to solve once again

Thanks and Regards,
Shailendra Kumar Singh