[Solved] Grid won't display

[Dan]

I have a grid page (using RadControls Q1 201) which has 2 slightly different searches.  One works fine.  The other just displays a single horizontal line instead of the grid.  The code all looks fine, the datasource is being defined correctly, the data retrieval stored procedure returns data if I run it manually.  Is there any way to diagnose this kind of problem where the grid just doesn't render?

Frustrated in Ohio

[Princy]

Hi Dan,

I guess your RadGrid is not displaying because,its not properly binding to the RadGrid.Please try binding using Advanced Data-binding (using NeedDataSource event).If the issue still exists please provide your code to replicate the issue.

Thanks,
Princy

[Jayesh Goyani]

Hello,

If you do not bind any record or bind null in RadGrid then it display single horizontal line.

After filtering if Stored Procedure return No value then please bind the empty array or string.empty (please check below link for more info).

http://www.telerik.com/community/forums/aspnet-ajax/grid/empty-datasource-radgrid-problem.aspx#1332764
http://www.telerik.com/community/forums/aspnet-ajax/grid/empty-radgrid-default-message.aspx#2337134
http://www.telerik.com/community/forums/aspnet-ajax/grid/display-an-empty-grid.aspx#833675


Thanks,
Jayesh Goyani

[Dan]

So, is it correct to say that Telerik no longer supports binding of a Radgrid to a DatasourceID, because this is the second time that older code of mine does not work.  For example binding a grid with:

SqlBuilder sbCommand = new SqlBuilder("OT", "MRN");

dsData.ConnectionString = sbCommand.GetConnectionString();

dsData.SelectCommand = "dbo.wa_MedicationProfile3";

dsData.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;

rgData.DataSourceID = "dsData";

rgData.MasterTableView.DataKeyNames = new string[] { "NO" };


[Andrey]

Hi,

RadGrid supports binding to datasource control. In fact almost eighty percent of RadGrid demo application are using SqlDataSource controls. You could verify this by visiting this online demo application and as well as many other.

Could you elaborate what is SqlBuilder since I was not able to find information on this type in MSDN. The closest thing I was able to find is SqlCommandBuilder. Could you try to refer to the connection string using the ConfigurationManager object.

Give this approach a try and let us know what is your status.

Regards,
Andrey
Telerik