Hey all , i seem to have this problem :

The data source does not support server-side data paging.

for my gridview . My codes for the connection to the gridview are :

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not IsPostBack Then

End If

End Sub

Sub LoadData()

Dim oledbCon As OleDbConnection = New OleDbConnection(System.Configuration.ConfigurationManager.AppSettings("Intermech"))

Dim sqlProduct, sqlCount As String

sqlProduct = "SELECT tbl_PRODUCT.IntermechID, tbl_PRODUCT.Description, tbl_PRODUCT.SellingPrice, tbl_CATEGORY.CategoryName FROM tbl_CATEGORY INNER JOIN tbl_PRODUCT ON tbl_CATEGORY.CategoryID = tbl_PRODUCT.CategoryID WHERE ACTIVE = True"

sqlCount = "Select count(*) As num FROM tbl_PRODUCT WHERE ACTIVE = TRUE"

Dim productCommand As New OleDbCommand

Try

productCommand = New OleDbCommand(sqlProduct, oledbCon)

Dim productCount As New OleDbCommand

productCount = New OleDbCommand(sqlCount, oledbCon)

Dim CountReader As Integer

lblStatus.Text = "There are currently " + CountReader.ToString + " Product(s) "

Dim productReader As OleDbDataReader

gv_Products.DataMember = "IntermechID"

Catch ex As Exception

Finally

If oledbCon.State = Data.ConnectionState.Open Then

End If

End Try

End Sub

Any help is appreciated ! Thank You in advance ! ;)