Intersoft Solutions - Community - WebCombo - reopen a WebCombo used in a WebGrid

Posted: November 5, 2012 12:18 PM in response to Bernard Xiang

Hi Bernard,

could you send me the complete project structure with the project file, currently I'm not able to run the example.

Thanks in advance

Vince

WebGrid_WebComboPersistText.zip

Bernard XiangMember

Posted: November 5, 2012 8:58 PM in response to Vincenzo Angeloni

Hi Vincenzo,

I couldn't send you the project here because the assembly is too big. But I've made you a simple way to run the project in your local end. First you can made new WebSite with Intersoft Empty Web Site template and then you can extract this files in your website. Then you can view in browser the WebGrid_WebComboPersistText.aspx files from you solution explorer. Hope this helps.

Regards,
Bernard

1 attachment

Posted: November 6, 2012 4:59 AM in response to Bernard Xiang

Hi Bernard

I have problems with the connection to the TrialProduct.mdf, I use this connection string:

<add name="TrialProductConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TrialProduct.mdf;Integrated Security=True"
providerName="System.Data.SqlClient"/>

but I have this error:

The database 'C:\PROJECTS\INTERSOFTSOLUTION\WEBAPP1\APP_DATA\TRIALPRODUCT.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'C:\PROJECTS\INTERSOFTSOLUTION\WEBAPP1\APP_DATA\TRIALPRODUCT.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Projects\IntersoftSolution\WebApp1\App_Data\TrialProduct.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Any idea?

Thanks

Vince

Posted: November 6, 2012 7:22 AM in response to Vincenzo Angeloni

Hi Bernard,

I was able to apply your suggestion to my project, using the dfault value for the interested colums after each row is added, but this does not match my request:

I would like to reopen the WebCombo automatically without that the WebCombo executes again the search server side because the result set is the same, but in this example the search is executed again
the row selected in the combo has to be the same selected before the grid row is added, but in this example the first row of the combo is selected

Is that possible?

Regards,

Vince

Bernard XiangMember

Posted: November 6, 2012 9:02 PM in response to Vincenzo Angeloni

Hi Vincenzo,

WebCombo only load the da]ta from database or server side only from the first loading. Then after that, it only take the data from the cache. That's default behaviour from WebCombo. On first matter maybe WebCombo load the data with the specific pattern that you saved in HiddenField. So you might be seeing WebCombo abit late to show its data. This is behaviour of WebCombo that we couldn't change. And for the second matter, we couldn't do this scenario because it will pop up and show the item with the same patter as default value. You can select the item that you want but it will change the value of WebCombo (example: Default value is 1111 and showed at new row, it pop up and select the 3rd row. The value of webcombo will change and it will make the resultbox has different row. It's not same like before). Hope this helps.

Regards,

Bernard

Posted: November 7, 2012 5:11 AM in response to Bernard Xiang

Hi Bernard,

the cache is IIS side or browser side?

Regards,

Daniele

Bernard XiangMember

Posted: November 7, 2012 11:30 PM in response to Vincenzo Angeloni

Hi Daniele,

I think you can choose whether it will be stored in PageCache (browser), Session (browser), or FileServer (IIS Server). You pick one of them as you cache storage by using DataCacheStorage property. WebCombo will load the data at first load then it will load the data from its cache while postback. Hope this helps.

Regards,
Bernard