Intersoft Community - WebGrid Enterprise - WebGrid and Custom Virtual Loading

WebGrid and Custom Virtual Loading

bernard — Wed, 01 Aug 2012 20:26:51 GMT

Hi John,

If you have any misconfiguration in my code, please let me know. I'll gladly help you to solve your problem.

Regards,
Bernard

WebGrid and Custom Virtual Loading

John.Bonin@dot.gov — Wed, 01 Aug 2012 06:59:50 GMT

Thanks Bernard, I'll take a look and will get back to you if I have any questions.

WebGrid and Custom Virtual Loading

bernard — Tue, 31 Jul 2012 00:52:48 GMT

Hi John,

Sorry for my late response. For this problem, I've a sample that using ObjectDataSource as WebGrid's DataSource. ObjectDataSource take a class as CustomObject and bind it into WebGrid. WebGrid also takes parameter in ObjectDataSource to configure the ClassicPaging's Custom PagingLoadMode. I also attach the sample here. Hope this helps.

Regards,

Bernard

WebGrid and Custom Virtual Loading

John.Bonin@dot.gov — Fri, 27 Jul 2012 06:50:39 GMT

Hi Bernard,

I've read the documentation before and that's why I ask a question here. The documentation uses a DataSet, I don't want to use the DataSet TableAdapter. I want to use a data class that acesses an Oracle Data Package. I guess from everything thus far, it is not possible to use this functionality without creating a dataset, so I guess I need to find a different solution.

Thanks

WebGrid and Custom Virtual Loading

bernard — Thu, 26 Jul 2012 22:05:15 GMT

Hi John,

I think this walkthough will help you. You can go to WebGrid's Documentation (http://intersoftpt.com/Support/WebGrid/Documentation/), go to Walkthrough Topics tab, then you can see Walkthrough: Implementing Custom Paging using ISDataSource inside Paging Data sub topic.

Hope this helps.

Regards,

Bernard

WebGrid and Custom Virtual Loading

John.Bonin@dot.gov — Thu, 26 Jul 2012 06:58:58 GMT

Hi Bernard,

I started using the ISDAtaSource but I guess I am still missing something as the maximumRows and startRowIndex is not sent to the control.

Here is the code for the ISDataSource within the aspx file with webGrid:

<isdatasource:isdatasource id="ISDataSource1" runat="server"    schematype="CustomObject" LoadOnDemand="True">
    <tables>
        <ISDataSource:ISDataSourceTable SelectMethod="getAllRDR" TypeName="RDRDetails" 
            TableName="RDRTable" SelectCountMethod="getAllRDRCount" EnablePaging="true">
            <SelectParameters>
                <asp:Parameter Name="_userID" Type="String" />
                <asp:Parameter Name="_where" Type="String" />
                <asp:Parameter Name="startRowIndex" Type="Int32" />
                <asp:Parameter Name="maximumRows" Type="Int32" />
                <asp:Parameter Name="sortExpression" Type="String" />
            </SelectParameters>
        </ISDataSource:ISDataSourceTable>
    </tables>
</isdatasource:isdatasource>

Here is the function getAllRDR in the Class object:
    <System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, False)> _
        Public Function getAllRDR(ByVal _userID As String, ByVal _where As String, ByVal startRowIndex As Integer, ByVal maximumRows As Integer, ByVal sortExpression As String) As DataTable
        Dim reader As OracleDataReader = Nothing
        Dim oDT As DataTable = New DataTable()
        _where = Replace(_where, "AND ", "WHERE ")
        Using conn As OracleConnection = New OracleConnection(ConfigurationManager.ConnectionStrings("conn").ToString)
            Dim cmd As OracleCommand = conn.CreateCommand()
            conn.Open()
            cmd.CommandText = "data_access.get_all_rdrs"
            cmd.CommandType = CommandType.StoredProcedure
            cmd.Parameters.Add("p_user", OracleDbType.Varchar2).Value = _userID
            cmd.Parameters.Add("p_where", OracleDbType.Varchar2).Value = _where
            cmd.Parameters.Add("p_start", OracleDbType.Decimal).Value = startRowIndex
            cmd.Parameters.Add("p_max", OracleDbType.Decimal).Value = maximumRows
            cmd.Parameters.Add("p_sort", OracleDbType.Varchar2).Value = sortExpression
            cmd.Parameters.Add("out_data", OracleDbType.RefCursor).Direction = ParameterDirection.InputOutput
            reader = cmd.ExecuteReader
            oDT.Load(reader, LoadOption.OverwriteChanges)
            reader.Close()
            Return oDT
        End Using
    End Function

When I put a breakpoint in the getALLRDR class an look at the parameters, startRowIndex and maximumRows is zero.

Not sure what I am missing here...

thanks

WebGrid and Custom Virtual Loading

bernard — Thu, 26 Jul 2012 04:14:47 GMT

Hi John,

Actually, you couldn't do Custom PagingLoadMode in ClassicPaging without using DataSource. WebGrid automatically sends the parameter to DataSource so it can configure its Paging. Currently, only ISDataSource and ObjectDataSource that support Paging. However, I recommend you to use ISDataSource for this scenario. ISDataSource can takes data from your class as CustomObject so you can do your paging. Hope this helps.

Regards,

Bernard

For more information, see http://intersoftpt.com/Support/WebGrid/Documentation/#url=topic511.html

WebGrid and Custom Virtual Loading

John.Bonin@dot.gov — Wed, 25 Jul 2012 06:42:01 GMT

Thanks Bernard, I'm not looking to display the index. I guess I didn't explain what I need.

I have database that has over 120K records, I want to use Custom Loading and Classic paging. I have a data class that calls an Oracle data package that gets the startRowIndex, maximumRecors and sortExpression which then returns 50 records at a time, when the user moved to the next page, the grid gets the next 50 records. I don't want to use a DataSource control and have my code pass these parameters to my data class. My question is can I do this without a data source control?

WebGrid and Custom Virtual Loading

bernard — Tue, 24 Jul 2012 23:26:59 GMT

Hi John,

From information that you mentioned above, you want to make Classic paging that show the index of data that has been loaded to WebGrid. You can do this with ClassicPaging but you must handle the index in client-side event.

I've made my own sample that show your scenario. In my sample I'm using Access Database instead of Oracle Database. And I'm not using DataSourceControl like your scenario. I attach my sample here.

Hope this helps.

Regards,

Bernard

WebGrid and Custom Virtual Loading

John.Bonin@dot.gov — Tue, 24 Jul 2012 12:04:32 GMT

I'm loading a grid using the InitializeDataSource event calling a Data Class to get 50 rows of data from an oracle database. In the InitializeDataSource event, I can get the sortExpression and the number of records to bring back, but I can't figure out how to get the startRowIndex from. I know it's simple but can't sem to figure it out!

MORE: I see that for PagingMode="VirtualLoad" this works fine, but I want to do ClassicPaging. Is there a way to do Custom Loading and Classic Paging without using a DataSource control?

Thanks

john