iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
Thank you, works perfectly...
Thank you Bernard. I'll be looking for the fix.
Thanks Bernard, I'll take a look and will get back to you if I have any questions.
<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
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.
Thank You, I will take a look shortly. Am in a release process at the moment.
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.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname