User Profile & Activity

John Bonin Member
Page
of 18
Posted: September 14, 2012 7:06 AM

Thank you, works perfectly...

Posted: August 3, 2012 6:25 AM

Thank you Bernard.  I'll be looking for the fix. 

Posted: August 1, 2012 6:59 AM

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

 

 

Posted: July 27, 2012 6:50 AM
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
Posted: July 26, 2012 6:58 AM
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



Posted: July 25, 2012 6:42 AM

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?

Thanks, I found out later that changing the doctype to xhtml showed correctly.

 

 

Hi, I am seeing the same problem with WebGrid 8 using IE 8.  Works fine in Firefox and Chrome.

Posted: June 21, 2012 7:12 AM

Thank You, I will take a look shortly.  Am in a release process at the moment.

Posted: June 18, 2012 7:00 AM

Thanks Hans, 

     In this case I didn't want to get the value, but need to recreate the select columns menu due to a bug in the postioning of the context menu.  I need a way to get the names of all the columns and whether they are hidden or not when the table is created.

All times are GMT -5. The time now is 5:42 PM.
Previous Next