Using the classic rad grid I was able to get a cell's value by doing the following:
VB code:
Public
Function GetDataTable(ByVal query As String) As DataTable
Dim connection2 As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\ENG101Exam.accdb;Persist" & _
" Security Info=True")
Dim adapter2 As New OleDbDataAdapter
adapter2.SelectCommand =
New OleDbCommand(query, connection2)
Dim table2 As New DataTable
connection2.Open()
Try
adapter2.Fill(table2)
Finally
connection2.Close()
End Try
Return table2
End Function
Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.WebControls.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource
RadGrid1.DataSource = GetDataTable(
"SELECT Teacher FROM [Teacher List] ")
End Sub
I can't get these routines to work using the grid for ASP.NET AJAX.
Can anyone help?
Thanks,
Tony

| <%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Sample.master.cs" Inherits="SGWWeb.MasterPages.Sample" %> |
| <!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>Untitled Page</title> |
| <asp:ContentPlaceHolder ID="head" runat="server"> |
| </asp:ContentPlaceHolder> |
| </head> |
| <body> |
| <form id="form1" runat="server"> |
| <div> |
| <asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server"> |
| </asp:ContentPlaceHolder> |
| </div> |
| </form> |
| </body> |
| </html> |
| <%@ Page Language="C#" MasterPageFile="~/MasterPages/Sample.Master" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="MyWeb.WebForm1" Title="Untitled Page" %> |
| <%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %> |
| <asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server"> |
| </asp:Content> |
| <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> |
| <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> |
| </telerik:RadScriptManager> |
| <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" |
| OldValuesParameterFormatString="original_{0}" |
| SelectMethod="GetHomepageProducts" |
| TypeName="MyApp.BLL.Items.HomepageItemsManager"></asp:ObjectDataSource> |
| <telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" |
| DataSourceID="ObjectDataSource1" GridLines="None"> |
| <MasterTableView datasourceid="ObjectDataSource1"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| </MasterTableView> |
| </telerik:RadGrid> |
| <telerik:RadAjaxManager runat="server"> |
| </telerik:RadAjaxManager> |
| </asp:Content> |