| <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" |
| AllowSorting="True" |
| AllowPaging="true" |
| ShowFooter="true" |
| DataSourceID="SqlDataSource1" |
| PageSize="100" |
| Skin="Web20" |
| Width="50%" |
| OnItemCommand="RadGrid1_ItemCommand" |
| AllowMultiRowSelection="True" |
| AutoGenerateColumns="False" |
| VirtualItemCount="10000" |
| OnSelectedIndexChanged="RadGrid1_SelectedIndexChanged"> |
| <ClientSettings> |
| <Scrolling AllowScroll="True" EnableVirtualScrollPaging="True" UseStaticHeaders="True"> |
| </Scrolling> |
| <ClientEvents OnScroll="HandleScrolling" /> |
| <Selecting AllowRowSelect="true" /> |
| </ClientSettings> |
| <SortingSettings SortedBackColor="BurlyWood" /> |
| <MasterTableView AllowNaturalSort="False" AllowSorting="False" DataKeyNames="Patient_id" DataSourceID="SqlDataSource1" > |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px" /> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridBoundColumn DataField="ID" DataType="System.Int32" EmptyDataText="&nbsp;" |
| HeaderText="ID" ReadOnly="True" SortExpression="ID" UniqueName="ID"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Name" EmptyDataText="&nbsp;" HeaderText="Name" |
| SortExpression="Name" UniqueName="Name"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| </MasterTableView> |
| <HeaderStyle Width="200px" /> |
| <PagerStyle Mode="Slider" /> |
| <SelectedItemStyle BackColor="#FFC0C0" /> |
| <FilterMenu EnableTheming="True" Skin="Vista"> |
| <CollapseAnimation Duration="200" Type="OutQuint" /> |
| </FilterMenu> |
| </telerik:RadGrid> |
My cells are coming blank when there is no value defined in the database or when they are null.