Radgrid returns no rows

[Joe]

I'm trying to use RadGrid with Oracel. I'm using the Devart Oracle provider. I want to use advanced binding. When this runs I get no rows to display message. Code included below.  any suggestions as to wha tI'm doing wrong? Version of contorls is v.2010.3.1109.35

 

<%

@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Default" %>

 

<%

@ Register assembly="Devart.Data.Oracle.Web, Version=5.35.54.0, Culture=neutral, PublicKeyToken=09af7300eec23701" namespace="Devart.Data.Oracle.Web" tagprefix="cc1" %>

 

 

 

 

<!

 

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

<

 

html xmlns="http://www.w3.org/1999/xhtml">

 

<

 

head runat="server">

 

 

 

 

 

 

<title></title>

 

 

 

 

 

 

<telerik:RadStyleSheetManager id="RadStyleSheetManager1" runat="server" />

 

</

 

head>

 

<

 

body>

 

 

 

 

 

 

<form id="form1" runat="server">

 

 

 

 

 

 

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

 

 

 

 

 

 

<Scripts>

 

 

 

 

 

<%

--Needed for JavaScript IntelliSense in VS2010--%>

 

<%

--For VS2008 replace RadScriptManager with ScriptManager--%>

 

 

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />

 

 

 

 

 

 

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />

 

 

 

 

 

 

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />

 

 

 

 

 

 

</Scripts>

 

 

 

 

 

 

</telerik:RadScriptManager>

 

 

 

 

 

 

<script type="text/javascript">

 

 

 

 

 

 

//Put your JavaScript code here.

 

 

 

 

 

 

</script>

 

 

 

 

 

 

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

 

 

 

 

 

 

</telerik:RadAjaxManager>

 

 

 

 

 

 

<div>

 

 

 

 

 

 

</div>

 

 

 

 

 

 

<telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None"

 

 

onneeddatasource="RadGrid1_NeedDataSource" >

 

 

 

 

 

 

 

 

 

<

 

HeaderContextMenu EnableImageSprites="True" CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>

 

<

 

MasterTableView AllowAutomaticUpdates="True" AutoGenerateColumns="False">

 

<

 

CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>

 

<

 

RowIndicatorColumn>

 

<

 

HeaderStyle Width="20px"></HeaderStyle>

 

</

 

RowIndicatorColumn>

 

<

 

ExpandCollapseColumn>

 

<

 

HeaderStyle Width="20px"></HeaderStyle>

 

</

 

ExpandCollapseColumn>

 

</

 

MasterTableView>

 

 

 

 

 

 

 

</telerik:RadGrid>

 

 

 

 

 

 

<cc1:OracleDataSource ID="OracleDataSource1" runat="server"

 

 

 

ConnectionString="User Id=user_name;Password=password;Server=PROD;Persist Security Info=True;"

 

 

OldValuesParameterFormatString="Original_{0}"

 

 

SelectCommand="select * from data_prequal.data_reporting">

 

 

 

 

 

 

</cc1:OracleDataSource>

 

 

 

 

 

 

</form>

 

</

 

body>

 

</

 

html>

 

 

 

using

 

System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Devart.Data.Oracle;
using System.Data;
using System.Configuration;
using System.Web.Security;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Telerik.Web.UI;

 

public

 

partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{if (Page.IsPostBack) return;
}

 

 

private DataTable GetOrdersDetails()
{
string ConnString = "User Id=user_name;Password=password;Server=PROD;Persist Security Info=True;";
string query = "SELECT * FROM data_reporting";
DataTable myDataTable = new DataTable();

 

 

using (OracleConnection conn = new OracleConnection(ConnString))
{
using (OracleDataAdapter adapter = new OracleDataAdapter())
{
adapter.SelectCommand = new OracleCommand(query, conn);
conn.Open();

 

 

try
{
adapter.Fill(myDataTable);
}

 

 

finally
{
conn.Close();
}

 

}

}

 

return myDataTable;

 

}

 

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
RadGrid1.DataSource = GetOrdersDetails();
}

 

}

 

 

 

 

 

[Princy]

Hello Joe,

Radgrid shows 'No records to display' message because you have not added any columns to Columns property collection of table view and you also set the AutoGenerateColumns property as 'False'. When you set AutoGenerateColumns="true" , a column is added for every field of the data source to which the table view is bound.

Hope this information helps,
Princy.