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
I am using intersoft multi selection webcombo in one of my application. I need to bind Approx. 200000 records with webcombo and to do this my page will be hang up.
Webcombo version : 4.0.7200.211
Technologies : .Net 2005 (vb)
Below is the code that I used to bind webcombo.
ASPX :
<iswebcombo:WebCombo ID="wcJob" runat="server" Width="150px" DataTextField="ShowId" TabIndex="8"
DataValueField="idSurvey" EnableViewState="false" LayoutSettings-TextBoxMode="Editable">
<FlyPostBackSettings PostViewState="False" PostHiddenFields="False" />
</iswebcombo:WebCombo>
Code File:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
wcJob.MultipleSelectionSettings.SeparatorChar = ";"
wcJob.MultipleSelectionSettings.Enabled = True
wcJob.MultipleSelectionSettings.AllowBrowseAll = False
wcJob.MultipleSelectionSettings.AutoPositionResultBox = False
End Sub
Protected Sub wcJob_InitializeDataSource(ByVal sender As Object, ByVal e As ISNet.WebUI.WebCombo.DataSourceEventArgs) Handles wcJob.InitializeDataSource
Dim objJob As New clsSurveys()
Dim dt As DataTable = objJob.GetJobNumberByIdSite(" idSite = " + getIdSite.ToString()) ‘Return 200000 records.
wcJob.ClearCachedDataSource()
wcJob.PopulateUnboundData(dt, True) ‘Code is hang up here.
objJob = Nothing
Please help me out where I am wrong . What can I do to stop, hang up my page.
The page would very long respond or slowly to load data because the amout is 200000. In fact, we don't suggest to load so many records in WebCombo. To avoid this issue, I suggest not to load all data by handling them by query. Also, we have 'MinCharsToRequest' in WebComboDesigner>>Advanced Settings properties. After user typed some chars, get and implement them into query for loading data.
Regards,Handy
Hi
If possible then please give me query how to implement this minCharsToRequest. And also please note that i am using multiselection webcombo and also at edit time i have to set that values like :
wcJob.SetMultipleValues(Showid,idSurvey)
Can you give me an example of source code which is used Query for bind webcombo? I am not using any DataSource.. i write select quey like : "Select TextField,ValueField from Table"
Regards,
Hiren Andharia
Still waiting for you reply...
Hi Hiren,
Sorry for waiting. Here is my sample. If you use MinimumCharToRequest properties, it would do query for your database and populate data.Unfortunately, this only works for single selection. In Multiple selection scenario, it only works for the first selection. You can see my simple sample. It also handles the query itself. So, i think you will also need to figure out how to populate your data by query manually by setting AllowAutoQueryHandler false. Hope this helps.
I got this Error
---------------------------Error---------------------------A Runtime Error has occurred.Do you wish to Debug?
Line: 9Error: 'ResultBox.document' is null or not an object---------------------------Yes No ---------------------------
Did you get the error after ran my sample? It works fine at here. Please ensure you have used the latest hotfix (WebCombo and WebUIFramework).
I am using Multiselectio webcombo thats why got these error. can you please give me code using multiselection webcombo. I really need this please help me out..
Hi,
Using multiple selection should not reproduce the error. In fact, my sample also used that. What i was trying to tell you that those properties would not work well in multiple selection because it is only triggered once af the first selection. Please ensure you have applied the latest hotfix.
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