Jul 31, 2012, 5:09 PM
GridPanel Databind Not Working
Hi,
I'm using a gridpanel and I want to load data from a select query into it. When I look in the datasource it has retrieved the correct row from the select query, but then it just doesn't bind that to the grid. The grid is being loaded but the fields remain blank. Heres my code:
Thanks
I'm using a gridpanel and I want to load data from a select query into it. When I look in the datasource it has retrieved the correct row from the select query, but then it just doesn't bind that to the grid. The grid is being loaded but the fields remain blank. Heres my code:
protected void Page_Load(object sender, EventArgs e)
{
OracleConnection oconnect = new OracleConnection(conStr);
oconnect.Open();
//get relevant data from oracle
OracleDataAdapter oInformation = new OracleDataAdapter("select description, risk_item, support_time_per_case,
occurences_per_month, estimated_fte_cost,"
+ " benefit_recipient, status from sprint_goals where function_name = '"+ area + "' order by goal", oconnect);
DataSet dsInformation = new DataSet();
oInformation.Fill(dsInformation);
Session["Data_tableTSK" + Request.QueryString[0].ToString()] = dsInformation.Tables[0];
this.Store1.DataSource = ((DataTable)Session[1]).DefaultView;
this.Store1.DataBind();
oconnect.Close();
}
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Current Sprint Goals</title>
<style type="text/css">
#form1
{
height: 111px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<ext:ResourceManager ID="ResourceManager1" runat="server" />
</div>
<ext:GridPanel
ID="GridPanel1"
runat="server"
StripeRows="true"
ClicksToEdit="1"
Title="Test Grid"
Width="1050"
MonitorResize="true"
Height="350">
<Store>
<ext:Store ID="Store1" runat="server" OnRefreshData="Store1_RefreshData">
<Reader>
<ext:ArrayReader>
<Fields>
<ext:RecordField Name="DESCRIPTION" Type="String"/>
<ext:RecordField Name="RISK_ITEM" Type="String"/>
<ext:RecordField Name="SUPPORT_TIME_PER_CASE" Type="Int"/>
<ext:RecordField Name="OCCURENCES_PER_MONTH" Type="Int"/>
<ext:RecordField Name="ESTIMATED_FTE_COST" Type="Float"/>
<ext:RecordField Name="BENEFIT_RECIPIENT" Type="String"/>
<ext:RecordField Name="STATUS" Type="String"/>
</Fields>
</ext:ArrayReader>
</Reader>
</ext:Store>
</Store>
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column ColumnID="DESCRIPTION" Header="Description" DataIndex="DESCRIPTION">
<Editor>
<ext:TextField ID="DescText" runat="server" />
</Editor>
</ext:Column>
<ext:Column ColumnID="RISK_ITEM" Header="Risk Item" DataIndex="RISK_ITEM">
<Editor>
<ext:ComboBox ID="RiskCombo" runat="server" >
</ext:ComboBox>
</Editor>
</ext:Column>
<ext:Column ColumnID="SUPPORT_TIME_PER_CASE" Header="Support Time Per Case" DataIndex="SUPPORT_TIME_PER_CASE">
<Editor>
<ext:TextField ID="SupportTimeText" runat="server" />
</Editor>
</ext:Column>
<ext:Column ColumnID="OCCURENCES_PER_MONTH" Header="Occurrences Per Month" DataIndex="OCCURENCES_PER_MONTH">
<Editor>
<ext:TextField ID="OccurText" runat="server" />
</Editor>
</ext:Column>
<ext:Column ColumnID="ESTIMATED_FTE_COST" Header="Estimated FTE Benefit" DataIndex="ESTIMATED_FTE_COST">
<Editor>
<ext:TextField ID="FTEText" runat="server" />
</Editor>
</ext:Column>
<ext:Column ColumnID="BENEFIT_RECIPIENT" Header="Benefit Recipient" DataIndex="BENEFIT_RECIPIENT">
<Editor>
<ext:ComboBox ID="BenefitRecipientComboBox" runat="server" >
</ext:ComboBox>
</Editor>
</ext:Column>
<ext:Column ColumnID="STATUS" Header="Status" DataIndex="STATUS">
<Editor>
<ext:ComboBox ID="StatusComboBox" runat="server" >
</ext:ComboBox>
</Editor>
</ext:Column>
</Columns>
</ColumnModel>
</ext:GridPanel>
</form>
</body>
</html>
Please can someone help, it seems so simple but I've had no luck so far.Thanks