Hi guys,
I have a radgrid in my apsx page:
I code behind file I am accessing data thru Store Procedure and returning Dataset:
This is my bind function:
For some reason only first 2 column populated with the data.I run debug and SP returns all 5 fields populated with the data.
Please help,
Thanks so much.
I have a radgrid in my apsx page:
<telerik:RadGrid ID="FundReportGrid" runat="server" GridLines="None"
Skin="Office2010Blue" AllowPaging="true" AllowSorting="true"
onexcelmlexportrowcreated="FundReportGrid_ExcelMLExportRowCreated"
onexcelmlexportstylescreated="FundReportGrid_ExcelMLExportStylesCreated"
onneeddatasource="FundReportGrid_NeedDataSource"
onpageindexchanged="FundReportGrid_PageIndexChanged"
onpagesizechanged="FundReportGrid_PageSizeChanged"
onpdfexporting="FundReportGrid_PdfExporting"
onselectedindexchanged="FundReportGrid_SelectedIndexChanged"
onsortcommand="FundReportGrid_SortCommand"
onitemcreated="FundReportGrid_ItemCreated">
<ExportSettings FileName="FundingIssueReport" OpenInNewWindow="true" IgnorePaging="true" ExportOnlyData="true">
<Excel Format="ExcelML" FileExtension="xls" />
<Pdf FontType="Subset" PaperSize="Letter" />
</ExportSettings>
<MasterTableView AutoGenerateColumns="false" AllowMultiColumnSorting="true">
<RowIndicatorColumn>
<HeaderStyle Width="1px" />
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="1px" />
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn HeaderText="Location" DataField="LOC" UniqueName="LOC" ReadOnly="true" SortExpression="LOC" HeaderButtonType="TextButton" >
<HeaderStyle Width="1px" />
<ItemStyle Width="1px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Job" DataField="JOB" UniqueName="JOB" ReadOnly="true" SortExpression="JOB" HeaderButtonType="TextButton" >
<HeaderStyle Width="1px" />
<ItemStyle Width="1px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Title" DataField="TITLE" UniqueName="TITLE" ReadOnly="true" SortExpression="TITLE" HeaderButtonType="TextButton" >
<HeaderStyle Width="1px" />
<ItemStyle Width="1px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="PD Code" DataField="PDIEM_CODE" UniqueName="PDIEM_CODE" ReadOnly="true" SortExpression="PDIEM_CODE" HeaderButtonType="TextButton" >
<HeaderStyle Width="1px" />
<ItemStyle Width="1px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Service Days" DataField="SERVICE_DAYS" UniqueName="SERVICE_DAYS" ReadOnly="true" SortExpression="SERVICE_DAYS" HeaderButtonType="TextButton" >
<HeaderStyle Width="1px" />
<ItemStyle Width="1px" />
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings EnableRowHoverStyle="true" EnablePostBackOnRowClick="true">
<Selecting AllowRowSelect="true" />
</ClientSettings>
</telerik:RadGrid>
I code behind file I am accessing data thru Store Procedure and returning Dataset:
DataSet
ds = new DataSet();
string jobstatus = string.Empty;
ds =
PerDiemCFNReport.CFN_Funding_Issue_Report(FiscalYear.ToString(), CFNList1.CFN, Location, JobTextBox.Text.Trim(), EMP_IDs1.SelectedID, EMP_IDs1.SelectedIDType, ref jobstatus);
if ((ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0) && (ds.Tables[0] != null))
{
Session[
"FundReportData"] = ds.Tables[0];
lblError.Text =
String.Empty;
lblError.Attributes.Add(
"display", "none");
FundingIssueReport.Visible =
true;
ErrorImage.Visible =
false;
BindFundIssueData();
FYDetail = CFNList1.Year;
GetDetailReport();
}
else
{
lblError.Visible =
true;
lblError.Text =
"No Data found for the given search criteria";
FundingIssueReport.Visible =
false;
FundingIssueDetailReport.Visible =
false;
ErrorImage.Visible =
true;
return;
}
This is my bind function:
private
void BindFundIssueData()
{
RadGrid FundIssueGrid = (RadGrid)FundingIssueReport.FindItemByValue("FundDataReport").FindControl("FundReportGrid");
FundIssueGrid.MasterTableView.CurrentPageIndex = 0;
FundIssueGrid.DataSource = Session[
"FundReportData"];
FundIssueGrid.DataBind();
}
For some reason only first 2 column populated with the data.I run debug and SP returns all 5 fields populated with the data.
Please help,
Thanks so much.