This question is locked. New answers and comments are not allowed.
I have to use oracle function to populate data in my radgrid.
My data access function is like code below , it is giving output as cursor
Public Function ACTIVE_PROMOS() As Integer Implements IEntitiesModelUnitOfWork.ACTIVE_PROMOS
Dim queryResult As Integer = Me.ExecuteNonQuery("SELECT ""PLUTO"".""INV_ATH"".""ACTIVE_PROMOS""() FROM dual", CommandType.Text)
Return queryResult
End Function
I have use this function as a datasource of my radgrid as attached. Please let me know how to do that
My data access function is like code below , it is giving output as cursor
Public Function ACTIVE_PROMOS() As Integer Implements IEntitiesModelUnitOfWork.ACTIVE_PROMOS
Dim queryResult As Integer = Me.ExecuteNonQuery("SELECT ""PLUTO"".""INV_ATH"".""ACTIVE_PROMOS""() FROM dual", CommandType.Text)
Return queryResult
End Function
I have use this function as a datasource of my radgrid as attached. Please let me know how to do that
Protected Sub rgCurrentPromo_NeedDataSource(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles rgCurrentPromo.NeedDataSource
Using dbContext As New AthenaModel.EntitiesModel()
Dim query As DataTable()
dbContext.ACTIVE_PROMOS()
rgCurrentPromo.DataSource = query
rgCurrentPromo.DataBind()
End Using
End Sub