Ok, so is there a viable solution for someone who is very particular about which columns are displayed and does not want to AutoGenerateColumns?

i.e. Is there a workaround that avoids both the annoyance of the "No Data to Display"error message (when there is, in fact data to display) and when auto-generating the columns is out of the question?

Thanks!

Hi JDawg,

I may be misunderstanding the issue here, but I see 2 possible options:

1. Manually add columns in the designer - they will show up at run time when there is no data to display
2. Create a query for the SQL DataSource that just gets the field definition and returns no data, so the column headers show up.  Select * from customers where 1 = 0.

You can also just remove the "No Data To Display" message.

Let me know if any of this made sense or if this won't work,

Thanks

Jason

Jason Beres"]...

2 possible options:

1. Manually add columns in the designer - they will show up at run time when there is no data to display
2. Create a query for the SQL DataSource that just gets the field definition and returns no data, so the column headers show up.  Select * from customers where 1 = 0.

You can also just remove the "No Data To Display" message.

...

Thanks for the response Jason. A couple things.

1. I had already added the columns in the designer.

2. I need to assign the datasource programmatically, so I'm not working with garden variety datasources by means of drag and drop DataSource controls.

Further explanation of the problem:
If I add some code to print out how many rows are returned from the datasource (and hence should be displayed), although there is definitely data present, the UltraWebGrid refuses to display it upon the initial render of the page. If i click on a random page element, such as a radio button and then click back to the default setting, the UltraWebGrid will render with the expected data.

So, for whatever reason, the initial page load will not render the data that is present, but instead returns the "No Data to Display" message, so it's not a case of just wanting the error message to disappear, I need the data that is actually being returned on the initial page load to display, rather than having to coax it by clicking on another random element on the page and back.

Any ideas on how to have it render properly on an initial page load?

TIA,

JD

Hello JD,

Can you post the page that you are running this issue with? I cannot think of any reason why the grid would fail to show the data during first load, but will show data if you click on a random element on the page.

One thing I would like you to check is to try binding your data to the GridView in the same way you are binding it to the WebGrid, and see if you see data during the initial load in the GridView. If you do, then this probably maybe a bug that we need to look into. In any case, if you attach a sample, that might help us determine what is going on and we can go from there.

Thanks,
Taz.

Hi Taz,

Thank you for your suggestions. The GridView does work during the initial load, while the WebGrid fails.

Here is a sample:

Imports System
Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web
Imports Infragistics.WebUI.UltraWebGrid
Imports GESlsOrd

Namespace GESlsOrd
    Partial Class WebGridTest
        Inherits System.Web.UI.Page

        Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

            Dim Acct As String = "413000"
            Dim Part As String = "CRYD2425D"

            If (rdoOrderListing.SelectedValue = "Closed") Then

                'GridView
                gvOrderListing_Open.Visible = False
                gvOrderListing_Closed.Visible = True
                gvOrderListing_Closed.DataSource = SlsOrdData.PHOrderListing_Closed(Acct, Part) 'DataTable
                gvOrderListing_Closed.DataBind()

                'UltraWebGrid
                UwgOrderListing_Open.Visible = False
                UwgOrderListing_Closed.Visible = True
                UwgOrderListing_Closed.DataSource = SlsOrdData.PHOrderListing_Closed(Acct, Part) 'DataTable
                UwgOrderListing_Closed.DataBind()

            Else ' If (rdoOrderListing.SelectedValue = "Open") Then

                'GridView
                gvOrderListing_Closed.Visible = False
                gvOrderListing_Open.Visible = True
                gvOrderListing_Open.DataSource = SlsOrdData.PHOrderListing_Open(Acct, Part) 'DataTable
                gvOrderListing_Open.DataBind()

                'UltraWebGrid
                UwgOrderListing_Closed.Visible = False
                UwgOrderListing_Open.Visible = True
                UwgOrderListing_Open.DataSource = SlsOrdData.PHOrderListing_Open(Acct, Part) 'DataTable
                UwgOrderListing_Open.DataBind()

            End If

        End Sub

    End Class
End Namespace

I have the same problem now, I am trying to upgrade by infragistics controls from 2011vol2 to Infragistics 2013 Vol3. When I load the data first time it is not showing any records, if I refresh or reload data I see all the data properly.

I am having the same problem, the only difference is that the "No Data To Display" are is not displayed all the time. It happens randomly, so much so that I cannot reproduce the issue to pin it down. The solution provided here  will probably not work for me. I am saying this because a quick search for the IsBound did not return anything. Is there any fundamental reason behind this behaiver?

Sweet! Thank you for the solution!!

Buddy remove the IsBound="True" from each column in WebGrid.

And it will work.