Hello,
I use version 17.2.
I have a misunderstanding about the use of the webhierarchicaldatasource of the webhierarchicaldatagrid.I use it with 2 SqlDataSource with parameters. (parent and child).
I have the property InitialDataBindDepth="-1", so i'm loading all data in one time.
I don't understand why i have N select on the detail select. I should have ONE select for the parent and ONE for the child, right ?
For example, if I have 5 affected rows after SDSFactureEnt_Selecting (parent), the SDSFactureDet_Selecting method(child) is repeating 5 times. Is that normal ?
it penalizes the performance of the web page.
Could you please send me the sample that you showcased 4 days ago? I've tried the online configuration from our website, although I didn't reproduce the behavior described so far.
Private case with number CAS-201888-T8C7N6 has been created for your convenience, where you can send files privately. In addition to the working sample, it would be very helpful to send me your database as well, below you will find a detailed explanation how to retrieve data plus schema from database, providing both the project and data would be highly appreciated and will help me to investigate the issue in a timely manner.
Steps to retrieve schema + data from a database:
1. Right click on the DataBase (testDb for example).2. Select "Tasks".3. Select "Generate Script".4. Click "Next" press radio button "Select specific database object"5. And Select all tables used in the App6. Click the Next button and select the "Advanced" button.7. From there find "Types of data to script" and change the value not to be "Schema only" but "Schema and data".8. Press "Ok" -> "Next" and "Finish".
Hi,
This happens when the page is loaded.
Is this happens first time when you load the grid or when you do a post back (for example form button click).
Also you do not need to call DataBind of the grid, this will be done form the source and is not needed. When the grid is loaded it is dabound from the code and calls the select commands from the data sources when you call DataBind form your code it calls the select commands again.
Sorry, it doesn't fix the issue.
I have the same behavior like the gif animated above.
Another idea ?
You can set the EnableDataViewState property to true, and it will decrease the database calls.
Here is more information about the property: https://www.infragistics.com/help/aspnet/webdatagrid-getting-started-with-webdatagrid-enabledataviewstate-property