asked on

RadGrid not displaying all the records

A have a telerik rad grid that is not displaying all the records in the recordset provided to it. The radgrid's datasource is a SQLDataSource. When if I run the sql statement in SSMS, I see all records.

Another isuue I have is have to debug the sqldatasource in Visual Studio.

Any thoughts?

lcohan

Could it be due to AllowPaging="true"? Maybe set AllowPaging="false" instead and also what if you set the PageSize programatically before you bind it like:

RadGrid1.PageSize = myCollection.Count;
RadGrid1.DataSource = myCollection;
RadGrid1.DataBind();

RayBakker

ASKER

Thanks for the quick response. I tried the paging, made no difference. I change the grid to use the NeedDatasouce. so could view the record set.

I see that the grid is getting 329 records will it should be getting 343 records. I tired to see what was common between those missing records and haven't found anything yet.

I will keep looking.

Thanks

Ryan Chong

also make sure the radgrid's datasource linked to the same schema as what linked in SSMS?

in your codes, try put the break points before the sql execution to make sure the correct parameters being passed.

also check if 329 is a distinct of 343 records?

RayBakker

ASKER

I found the issue. it was not in the connection to the the gird but rather the query bad data in the query result.

ASKER CERTIFIED SOLUTION

RayBakker

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial