This is a migrated thread and some comments may be shown as answers.

2011 Q1 Select Parent Child Tables

1 Answer 72 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Bill
Top achievements
Rank 1
Bill asked on 22 Jun 2011, 11:37 PM
I just migrated to 2011 version, and I cannot find where to add the select button.

I have a master table and a child table. I used to be able to add a select button/link at master table and would show related records in child table when clicked. Can you tell me how to do that in 2011?

Thanks

Bil


here is my aspx

<%

@ Page Language="VB" AutoEventWireup="false" CodeFile="SchedulingOptions.aspx.vb" Inherits="SchedulingOptions" %>

 

<%

@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

 

<!

 

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>

 

 

<style type="text/css">

 

 

#form1

 

{

 

text-align: center;

 

}

 

</style>

 

</

 

head>

 

<

 

body>

 

 

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

 

 

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

 

 

</telerik:RadScriptManager>

 

 

<div style="text-align: left">

 

 

 

<br />

 

 

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

 

 

ConnectionString="<%$ ConnectionStrings:5ConnectionString1 %>"

 

 

DeleteCommand="DELETE FROM [s_ServiceScheduling] WHERE [ServiceID] = @ServiceID"

 

 

InsertCommand="INSERT INTO [s_ServiceScheduling] ([Online_RequestsID], [Service], [Service_Description], [Display_Order], [PreBookMaxTime], [PrebookMaxTimeUnits], [PrebookMinTime], [PrebookMikTimeUnits], [CancelMaxTime], [CancelMaxTimeUnits], [AllowCancel], [PrePaymentRequired], [Service_Type], [Servicee_Title], [Server_Title], [Booking_Title], [BaseAddress], [BaseCity], [BaseState], [BaseZipCode], [Active]) VALUES (@Online_RequestsID, @Service, @Service_Description, @Display_Order, @PreBookMaxTime, @PrebookMaxTimeUnits, @PrebookMinTime, @PrebookMikTimeUnits, @CancelMaxTime, @CancelMaxTimeUnits, @AllowCancel, @PrePaymentRequired, @Service_Type, @Servicee_Title, @Server_Title, @Booking_Title, @BaseAddress, @BaseCity, @BaseState, @BaseZipCode, @Active)"

 

 

ProviderName="<%$ ConnectionStrings:5ConnectionString1.ProviderName %>"

 

 

SelectCommand="SELECT [ServiceID], [Online_RequestsID], [Service], [Service_Description], [Display_Order], [PreBookMaxTime], [PrebookMaxTimeUnits], [PrebookMinTime], [PrebookMikTimeUnits], [CancelMaxTime], [CancelMaxTimeUnits], [AllowCancel], [PrePaymentRequired], [Service_Type], [Servicee_Title], [Server_Title], [Booking_Title], [BaseAddress], [BaseCity], [BaseState], [BaseZipCode], [Active] FROM [s_ServiceScheduling]"

 

 

UpdateCommand="UPDATE [s_ServiceScheduling] SET [Online_RequestsID] = @Online_RequestsID, [Service] = @Service, [Service_Description] = @Service_Description, [Display_Order] = @Display_Order, [PreBookMaxTime] = @PreBookMaxTime, [PrebookMaxTimeUnits] = @PrebookMaxTimeUnits, [PrebookMinTime] = @PrebookMinTime, [PrebookMikTimeUnits] = @PrebookMikTimeUnits, [CancelMaxTime] = @CancelMaxTime, [CancelMaxTimeUnits] = @CancelMaxTimeUnits, [AllowCancel] = @AllowCancel, [PrePaymentRequired] = @PrePaymentRequired, [Service_Type] = @Service_Type, [Servicee_Title] = @Servicee_Title, [Server_Title] = @Server_Title, [Booking_Title] = @Booking_Title, [BaseAddress] = @BaseAddress, [BaseCity] = @BaseCity, [BaseState] = @BaseState, [BaseZipCode] = @BaseZipCode, [Active] = @Active WHERE [ServiceID] = @ServiceID">

 

 

<DeleteParameters>

 

 

<asp:Parameter Name="ServiceID" Type="Int32" />

 

 

</DeleteParameters>

 

 

<InsertParameters>

 

 

<asp:Parameter Name="Online_RequestsID" Type="Int32" />

 

 

<asp:Parameter Name="Service" Type="String" />

 

 

<asp:Parameter Name="Service_Description" Type="String" />

 

 

<asp:Parameter Name="Display_Order" Type="Int32" />

 

 

<asp:Parameter Name="PreBookMaxTime" Type="Int32" />

 

 

<asp:Parameter Name="PrebookMaxTimeUnits" Type="String" />

 

 

<asp:Parameter Name="PrebookMinTime" Type="Int32" />

 

 

<asp:Parameter Name="PrebookMikTimeUnits" Type="String" />

 

 

<asp:Parameter Name="CancelMaxTime" Type="Int32" />

 

 

<asp:Parameter Name="CancelMaxTimeUnits" Type="String" />

 

 

<asp:Parameter Name="AllowCancel" Type="Boolean" />

 

 

<asp:Parameter Name="PrePaymentRequired" Type="Boolean" />

 

 

<asp:Parameter Name="Service_Type" Type="String" />

 

 

<asp:Parameter Name="Servicee_Title" Type="String" />

 

 

<asp:Parameter Name="Server_Title" Type="String" />

 

 

<asp:Parameter Name="Booking_Title" Type="String" />

 

 

<asp:Parameter Name="BaseAddress" Type="String" />

 

 

<asp:Parameter Name="BaseCity" Type="String" />

 

 

<asp:Parameter Name="BaseState" Type="String" />

 

 

<asp:Parameter Name="BaseZipCode" Type="String" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

</InsertParameters>

 

 

<UpdateParameters>

 

 

<asp:Parameter Name="Online_RequestsID" Type="Int32" />

 

 

<asp:Parameter Name="Service" Type="String" />

 

 

<asp:Parameter Name="Service_Description" Type="String" />

 

 

<asp:Parameter Name="Display_Order" Type="Int32" />

 

 

<asp:Parameter Name="PreBookMaxTime" Type="Int32" />

 

 

<asp:Parameter Name="PrebookMaxTimeUnits" Type="String" />

 

 

<asp:Parameter Name="PrebookMinTime" Type="Int32" />

 

 

<asp:Parameter Name="PrebookMikTimeUnits" Type="String" />

 

 

<asp:Parameter Name="CancelMaxTime" Type="Int32" />

 

 

<asp:Parameter Name="CancelMaxTimeUnits" Type="String" />

 

 

<asp:Parameter Name="AllowCancel" Type="Boolean" />

 

 

<asp:Parameter Name="PrePaymentRequired" Type="Boolean" />

 

 

<asp:Parameter Name="Service_Type" Type="String" />

 

 

<asp:Parameter Name="Servicee_Title" Type="String" />

 

 

<asp:Parameter Name="Server_Title" Type="String" />

 

 

<asp:Parameter Name="Booking_Title" Type="String" />

 

 

<asp:Parameter Name="BaseAddress" Type="String" />

 

 

<asp:Parameter Name="BaseCity" Type="String" />

 

 

<asp:Parameter Name="BaseState" Type="String" />

 

 

<asp:Parameter Name="BaseZipCode" Type="String" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

<asp:Parameter Name="ServiceID" Type="Int32" />

 

 

</UpdateParameters>

 

 

</asp:SqlDataSource>

 

 

<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True"

 

 

AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowSorting="True"

 

 

AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True"

 

 

AutoGenerateHierarchy="True" CellSpacing="0" DataSourceID="SqlDataSource1"

 

 

GridLines="None">

 

<

 

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

 

<

 

MasterTableView AllowAutomaticDeletes="False" AllowAutomaticInserts="False"

 

 

AllowAutomaticUpdates="False" AllowSorting="False" AutoGenerateColumns="False"

 

 

CommandItemDisplay="Top" DataKeyNames="ServiceID" DataSourceID="SqlDataSource1">

 

<

 

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

 

<

 

RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

 

</

 

RowIndicatorColumn>

 

<

 

ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

 

</

 

ExpandCollapseColumn>

 

 

<Columns>

 

 

<telerik:GridBoundColumn DataField="ServiceID" DataType="System.Int32"

 

 

FilterControlAltText="Filter ServiceID column" HeaderText="ServiceID"

 

 

ReadOnly="True" SortExpression="ServiceID" UniqueName="ServiceID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Online_RequestsID" DataType="System.Int32"

 

 

FilterControlAltText="Filter Online_RequestsID column"

 

 

HeaderText="Online_RequestsID" SortExpression="Online_RequestsID"

 

 

UniqueName="Online_RequestsID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Service"

 

 

FilterControlAltText="Filter Service column" HeaderText="Service"

 

 

SortExpression="Service" UniqueName="Service">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Service_Description"

 

 

FilterControlAltText="Filter Service_Description column"

 

 

HeaderText="Service_Description" SortExpression="Service_Description"

 

 

UniqueName="Service_Description">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Display_Order" DataType="System.Int32"

 

 

FilterControlAltText="Filter Display_Order column" HeaderText="Display_Order"

 

 

SortExpression="Display_Order" UniqueName="Display_Order">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="PreBookMaxTime" DataType="System.Int32"

 

 

FilterControlAltText="Filter PreBookMaxTime column" HeaderText="PreBookMaxTime"

 

 

SortExpression="PreBookMaxTime" UniqueName="PreBookMaxTime">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="PrebookMaxTimeUnits"

 

 

FilterControlAltText="Filter PrebookMaxTimeUnits column"

 

 

HeaderText="PrebookMaxTimeUnits" SortExpression="PrebookMaxTimeUnits"

 

 

UniqueName="PrebookMaxTimeUnits">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="PrebookMinTime" DataType="System.Int32"

 

 

FilterControlAltText="Filter PrebookMinTime column" HeaderText="PrebookMinTime"

 

 

SortExpression="PrebookMinTime" UniqueName="PrebookMinTime">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="PrebookMikTimeUnits"

 

 

FilterControlAltText="Filter PrebookMikTimeUnits column"

 

 

HeaderText="PrebookMikTimeUnits" SortExpression="PrebookMikTimeUnits"

 

 

UniqueName="PrebookMikTimeUnits">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="CancelMaxTime" DataType="System.Int32"

 

 

FilterControlAltText="Filter CancelMaxTime column" HeaderText="CancelMaxTime"

 

 

SortExpression="CancelMaxTime" UniqueName="CancelMaxTime">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="CancelMaxTimeUnits"

 

 

FilterControlAltText="Filter CancelMaxTimeUnits column"

 

 

HeaderText="CancelMaxTimeUnits" SortExpression="CancelMaxTimeUnits"

 

 

UniqueName="CancelMaxTimeUnits">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridCheckBoxColumn DataField="AllowCancel" DataType="System.Boolean"

 

 

FilterControlAltText="Filter AllowCancel column" HeaderText="AllowCancel"

 

 

SortExpression="AllowCancel" UniqueName="AllowCancel">

 

 

</telerik:GridCheckBoxColumn>

 

 

<telerik:GridCheckBoxColumn DataField="PrePaymentRequired"

 

 

DataType="System.Boolean"

 

 

FilterControlAltText="Filter PrePaymentRequired column"

 

 

HeaderText="PrePaymentRequired" SortExpression="PrePaymentRequired"

 

 

UniqueName="PrePaymentRequired">

 

 

</telerik:GridCheckBoxColumn>

 

 

<telerik:GridBoundColumn DataField="Service_Type"

 

 

FilterControlAltText="Filter Service_Type column" HeaderText="Service_Type"

 

 

SortExpression="Service_Type" UniqueName="Service_Type">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Servicee_Title"

 

 

FilterControlAltText="Filter Servicee_Title column" HeaderText="Servicee_Title"

 

 

SortExpression="Servicee_Title" UniqueName="Servicee_Title">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Server_Title"

 

 

FilterControlAltText="Filter Server_Title column" HeaderText="Server_Title"

 

 

SortExpression="Server_Title" UniqueName="Server_Title">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Booking_Title"

 

 

FilterControlAltText="Filter Booking_Title column" HeaderText="Booking_Title"

 

 

SortExpression="Booking_Title" UniqueName="Booking_Title">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="BaseAddress"

 

 

FilterControlAltText="Filter BaseAddress column" HeaderText="BaseAddress"

 

 

SortExpression="BaseAddress" UniqueName="BaseAddress">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="BaseCity"

 

 

FilterControlAltText="Filter BaseCity column" HeaderText="BaseCity"

 

 

SortExpression="BaseCity" UniqueName="BaseCity">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="BaseState"

 

 

FilterControlAltText="Filter BaseState column" HeaderText="BaseState"

 

 

SortExpression="BaseState" UniqueName="BaseState">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="BaseZipCode"

 

 

FilterControlAltText="Filter BaseZipCode column" HeaderText="BaseZipCode"

 

 

SortExpression="BaseZipCode" UniqueName="BaseZipCode">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridCheckBoxColumn DataField="Active" DataType="System.Boolean"

 

 

FilterControlAltText="Filter Active column" HeaderText="Active"

 

 

SortExpression="Active" UniqueName="Active">

 

 

</telerik:GridCheckBoxColumn>

 

 

<telerik:GridButtonColumn FilterControlAltText="Filter column column"

 

 

UniqueName="column">

 

 

</telerik:GridButtonColumn>

 

 

<telerik:GridHyperLinkColumn FilterControlAltText="Filter column1 column"

 

 

UniqueName="column1">

 

 

</telerik:GridHyperLinkColumn>

 

 

</Columns>

 

<

 

EditFormSettings>

 

<

 

EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>

 

</

 

EditFormSettings>

 

</

 

MasterTableView>

 

 

<ClientSettings>

 

 

<Selecting AllowRowSelect="True" />

 

 

</ClientSettings>

 

<

 

FilterMenu EnableImageSprites="False"></FilterMenu>

 

 

</telerik:RadGrid>

 

 

<br />

 

 

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False"

 

 

DataKeyNames="ServerID" DataSourceID="SqlDataSource2"

 

 

EmptyDataText="There are no data records to display.">

 

 

<Columns>

 

 

<asp:BoundField DataField="ServerID" HeaderText="ServerID" ReadOnly="True"

 

 

SortExpression="ServerID" />

 

 

<asp:BoundField DataField="UserID" HeaderText="UserID"

 

 

SortExpression="UserID" />

 

 

<asp:BoundField DataField="UserName" HeaderText="UserName"

 

 

SortExpression="UserName" />

 

 

<asp:BoundField DataField="First_Name" HeaderText="First_Name"

 

 

SortExpression="First_Name" />

 

 

<asp:BoundField DataField="MI" HeaderText="MI" SortExpression="MI" />

 

 

<asp:BoundField DataField="Last_Name" HeaderText="Last_Name"

 

 

SortExpression="Last_Name" />

 

 

<asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />

 

 

<asp:BoundField DataField="Password" HeaderText="Password"

 

 

SortExpression="Password" />

 

 

<asp:BoundField DataField="Role" HeaderText="Role" SortExpression="Role" />

 

 

<asp:CheckBoxField DataField="Active" HeaderText="Active"

 

 

SortExpression="Active" />

 

 

</Columns>

 

 

</asp:GridView>

 

 

<asp:SqlDataSource ID="SqlDataSource2" runat="server"

 

 

ConnectionString="<%$ ConnectionStrings:5ConnectionString1 %>"

 

 

DeleteCommand="DELETE FROM [s_ServiceServers] WHERE [ServerID] = @ServerID"

 

 

InsertCommand="INSERT INTO [s_ServiceServers] ([UserID], [UserName], [First_Name], [MI], [Last_Name], [email], [Password], [Role], [Active]) VALUES (@UserID, @UserName, @First_Name, @MI, @Last_Name, @email, @Password, @Role, @Active)"

 

 

ProviderName="<%$ ConnectionStrings:5ConnectionString1.ProviderName %>"

 

 

SelectCommand="SELECT [ServerID], [UserID], [UserName], [First_Name], [MI], [Last_Name], [email], [Password], [Role], [Active] FROM [s_ServiceServers]"

 

 

UpdateCommand="UPDATE [s_ServiceServers] SET [UserID] = @UserID, [UserName] = @UserName, [First_Name] = @First_Name, [MI] = @MI, [Last_Name] = @Last_Name, [email] = @email, [Password] = @Password, [Role] = @Role, [Active] = @Active WHERE [ServerID] = @ServerID">

 

 

<DeleteParameters>

 

 

<asp:Parameter Name="ServerID" Type="Int32" />

 

 

</DeleteParameters>

 

 

<InsertParameters>

 

 

<asp:Parameter Name="UserID" Type="Int32" />

 

 

<asp:Parameter Name="UserName" Type="String" />

 

 

<asp:Parameter Name="First_Name" Type="String" />

 

 

<asp:Parameter Name="MI" Type="String" />

 

 

<asp:Parameter Name="Last_Name" Type="String" />

 

 

<asp:Parameter Name="email" Type="String" />

 

 

<asp:Parameter Name="Password" Type="String" />

 

 

<asp:Parameter Name="Role" Type="String" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

</InsertParameters>

 

 

<UpdateParameters>

 

 

<asp:Parameter Name="UserID" Type="Int32" />

 

 

<asp:Parameter Name="UserName" Type="String" />

 

 

<asp:Parameter Name="First_Name" Type="String" />

 

 

<asp:Parameter Name="MI" Type="String" />

 

 

<asp:Parameter Name="Last_Name" Type="String" />

 

 

<asp:Parameter Name="email" Type="String" />

 

 

<asp:Parameter Name="Password" Type="String" />

 

 

<asp:Parameter Name="Role" Type="String" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

<asp:Parameter Name="ServerID" Type="Int32" />

 

 

</UpdateParameters>

 

 

</asp:SqlDataSource>

 

 

<br />

 

 

<asp:SqlDataSource ID="SqlDataSource3" runat="server"

 

 

ConnectionString="<%$ ConnectionStrings:5ConnectionString1 %>"

 

 

DeleteCommand="DELETE FROM [s_ServiceAvailability] WHERE [AvailabilityID] = @AvailabilityID"

 

 

InsertCommand="INSERT INTO [s_ServiceAvailability] ([ServiceID], [UserID], [Category], [Description], [Availability], [Recurrence], [Day], [During], [From1], [To1], [Starting], [Ending], [Active]) VALUES (@ServiceID, @UserID, @Category, @Description, @Availability, @Recurrence, @Day, @During, @From1, @To1, @Starting, @Ending, @Active)"

 

 

ProviderName="<%$ ConnectionStrings:5ConnectionString1.ProviderName %>"

 

 

SelectCommand="SELECT [AvailabilityID], [ServiceID], [UserID], [Category], [Description], [Availability], [Recurrence], [Day], [During], [From1], [To1], [Starting], [Ending], [Active] FROM [s_ServiceAvailability] WHERE ([ServiceID] = @ServiceID)"

 

 

UpdateCommand="UPDATE [s_ServiceAvailability] SET [ServiceID] = @ServiceID, [UserID] = @UserID, [Category] = @Category, [Description] = @Description, [Availability] = @Availability, [Recurrence] = @Recurrence, [Day] = @Day, [During] = @During, [From1] = @From1, [To1] = @To1, [Starting] = @Starting, [Ending] = @Ending, [Active] = @Active WHERE [AvailabilityID] = @AvailabilityID">

 

 

<SelectParameters>

 

 

<asp:ControlParameter ControlID="RadGrid1" Name="ServiceID"

 

 

PropertyName="SelectedValue" Type="Int32" />

 

 

</SelectParameters>

 

 

<DeleteParameters>

 

 

<asp:Parameter Name="AvailabilityID" Type="Int32" />

 

 

</DeleteParameters>

 

 

<InsertParameters>

 

 

<asp:Parameter Name="ServiceID" Type="Int32" />

 

 

<asp:Parameter Name="UserID" Type="Int32" />

 

 

<asp:Parameter Name="Category" Type="String" />

 

 

<asp:Parameter Name="Description" Type="String" />

 

 

<asp:Parameter Name="Availability" Type="Boolean" />

 

 

<asp:Parameter Name="Recurrence" Type="String" />

 

 

<asp:Parameter Name="Day" Type="String" />

 

 

<asp:Parameter Name="During" Type="String" />

 

 

<asp:Parameter DbType="Time" Name="From1" />

 

 

<asp:Parameter DbType="Time" Name="To1" />

 

 

<asp:Parameter Name="Starting" Type="DateTime" />

 

 

<asp:Parameter Name="Ending" Type="DateTime" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

</InsertParameters>

 

 

<UpdateParameters>

 

 

<asp:Parameter Name="ServiceID" Type="Int32" />

 

 

<asp:Parameter Name="UserID" Type="Int32" />

 

 

<asp:Parameter Name="Category" Type="String" />

 

 

<asp:Parameter Name="Description" Type="String" />

 

 

<asp:Parameter Name="Availability" Type="Boolean" />

 

 

<asp:Parameter Name="Recurrence" Type="String" />

 

 

<asp:Parameter Name="Day" Type="String" />

 

 

<asp:Parameter Name="During" Type="String" />

 

 

<asp:Parameter DbType="Time" Name="From1" />

 

 

<asp:Parameter DbType="Time" Name="To1" />

 

 

<asp:Parameter Name="Starting" Type="DateTime" />

 

 

<asp:Parameter Name="Ending" Type="DateTime" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

<asp:Parameter Name="AvailabilityID" Type="Int32" />

 

 

</UpdateParameters>

 

 

</asp:SqlDataSource>

 

 

<telerik:RadGrid ID="RadGrid2" runat="server" CellSpacing="0"

 

 

DataSourceID="SqlDataSource3" GridLines="None">

 

<

 

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

 

<

 

MasterTableView AutoGenerateColumns="False" DataKeyNames="AvailabilityID"

 

 

DataSourceID="SqlDataSource3">

 

<

 

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

 

<

 

RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

 

<

 

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

 

</

 

RowIndicatorColumn>

 

<

 

ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

 

<

 

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

 

</

 

ExpandCollapseColumn>

 

 

<Columns>

 

 

<telerik:GridBoundColumn DataField="AvailabilityID" DataType="System.Int32"

 

 

FilterControlAltText="Filter AvailabilityID column" HeaderText="AvailabilityID"

 

 

ReadOnly="True" SortExpression="AvailabilityID" UniqueName="AvailabilityID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="ServiceID" DataType="System.Int32"

 

 

FilterControlAltText="Filter ServiceID column" HeaderText="ServiceID"

 

 

SortExpression="ServiceID" UniqueName="ServiceID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="UserID" DataType="System.Int32"

 

 

FilterControlAltText="Filter UserID column" HeaderText="UserID"

 

 

SortExpression="UserID" UniqueName="UserID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Category"

 

 

FilterControlAltText="Filter Category column" HeaderText="Category"

 

 

SortExpression="Category" UniqueName="Category">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Description"

 

 

FilterControlAltText="Filter Description column" HeaderText="Description"

 

 

SortExpression="Description" UniqueName="Description">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridCheckBoxColumn DataField="Availability" DataType="System.Boolean"

 

 

FilterControlAltText="Filter Availability column" HeaderText="Availability"

 

 

SortExpression="Availability" UniqueName="Availability">

 

 

</telerik:GridCheckBoxColumn>

 

 

<telerik:GridBoundColumn DataField="Recurrence"

 

 

FilterControlAltText="Filter Recurrence column" HeaderText="Recurrence"

 

 

SortExpression="Recurrence" UniqueName="Recurrence">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Day"

 

 

FilterControlAltText="Filter Day column" HeaderText="Day" SortExpression="Day"

 

 

UniqueName="Day">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="During"

 

 

FilterControlAltText="Filter During column" HeaderText="During"

 

 

SortExpression="During" UniqueName="During">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="From1" DataType="System.TimeSpan"

 

 

FilterControlAltText="Filter From1 column" HeaderText="From1"

 

 

SortExpression="From1" UniqueName="From1">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="To1" DataType="System.TimeSpan"

 

 

FilterControlAltText="Filter To1 column" HeaderText="To1" SortExpression="To1"

 

 

UniqueName="To1">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Starting" DataType="System.DateTime"

 

 

FilterControlAltText="Filter Starting column" HeaderText="Starting"

 

 

SortExpression="Starting" UniqueName="Starting">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Ending" DataType="System.DateTime"

 

 

FilterControlAltText="Filter Ending column" HeaderText="Ending"

 

 

SortExpression="Ending" UniqueName="Ending">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridCheckBoxColumn DataField="Active" DataType="System.Boolean"

 

 

FilterControlAltText="Filter Active column" HeaderText="Active"

 

 

SortExpression="Active" UniqueName="Active">

 

 

</telerik:GridCheckBoxColumn>

 

 

</Columns>

 

<

 

EditFormSettings>

 

<

 

EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>

 

</

 

EditFormSettings>

 

</

 

MasterTableView>

 

<

 

FilterMenu EnableImageSprites="False"></FilterMenu>

 

 

</telerik:RadGrid>

 

 

<br />

 

 

<br />

 

 

<br />

 

 

<br />

 

 

<br />

 

 

<br />

 

 

<br />

 

 

 

</div>

 

 

<telerik:RadTabStrip ID="RadTabStrip1" runat="server" Height="22px"

 

 

MultiPageID="RadMultiPage1" SelectedIndex="0" Width="980px">

 

 

<Tabs>

 

 

<telerik:RadTab runat="server" PageViewID="RadPageView1" Text="General Options"

 

 

BackColor="#FFC0C0" Selected="True">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" PageViewID="RadPageView2"

 

 

Text="Scheduling Option">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Servers">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Availability">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Cancelations">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Steps">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Fees">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Services">

 

 

</telerik:RadTab>

 

 

</Tabs>

 

 

</telerik:RadTabStrip>

 

 

<telerik:RadMultiPage ID="RadMultiPage1" Runat="server" BorderStyle="Solid"

 

 

BorderWidth="1px" SelectedIndex="0" Width="980px">

 

 

<telerik:RadPageView ID="RadPageView1" runat="server" Height="269px"

 

 

Width="980px" BackColor="#D4D5C4">

 

 

<br />

 

 

<table align="left" cellpadding="5">

 

 

<tr>

 

 

<td style="text-align: right">

 

 

<asp:Label ID="Label12" runat="server"

 

 

Text="Generally this type of service is called"></asp:Label>

 

 

</td>

 

 

<td>

 

 

<asp:TextBox ID="TextBox9" runat="server" Width="380px">Appointment</asp:TextBox>

 

 

</td>

 

 

</tr>

 

 

<tr>

 

 

<td style="text-align: right">

 

 

<asp:Label ID="Label13" runat="server"

 

 

Text="The receiver of the service is called">

 

 

</asp:label>

 

 

</td>

 

 

<td>

 

 

<asp:TextBox ID="TextBox10" runat="server" Width="380px">Patient</asp:TextBox>

 

 

</td>

 

 

</tr>

 

 

<tr>

 

 

<td>

 

 

<asp:Label ID="Label14" runat="server"

 

 

Text="The person rendering the service is called"></asp:Label>

 

 

</td>

 

 

<td>

 

 

<asp:TextBox ID="TextBox11" runat="server" Width="380px">Doctor</asp:TextBox>

 

 

</td>

 

 

</tr>

 

 

<tr>

 

 

<td style="text-align: right">

 

 

<asp:Label ID="Label15" runat="server" Text="The request process is called"></asp:Label>

 

 

</td>

 

 

<td>

 

 

<asp:TextBox ID="TextBox12" runat="server" Width="380px">Booking</asp:TextBox>

 

 

</td>

 

 

</tr>

 

 

</table>

 

 

</telerik:RadPageView>

 

 

<telerik:RadPageView ID="RadPageView2" runat="server" Height="296px"

 

 

Width="980px" BackColor="#D4D5C4">

 

 

<br />

 

 

<br />

 

 

<br />

 

 

</telerik:RadPageView>

 

 

<telerik:RadPageView ID="RadPageView3" runat="server" Height="272px"

 

 

Width="416px">

 

 

</telerik:RadPageView>

 

 

</telerik:RadMultiPage>

 

 

</form>

 

</

 

body>

 

</

 

html>

 

l

1 Answer, 1 is accepted

Sort by
0
Marin
Telerik team
answered on 27 Jun 2011, 05:46 PM
Hello Bill,

 You can have a look at the demos of the grid showing the available options for selecting in RadGrid:
Server-side row selection
Client-side row selection

Those functionalities have not been changed recently unless you are upgrading from the classical version of the ASP.NET controls. Can you specify how you had the selection configured in the previous version?
Normally adding a simple button column should be enough:

<telerik:GridButtonColumn Text="Select" CommandName="Select">
</telerik:GridButtonColumn>

All the best,
Marin
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Tags
Grid
Asked by
Bill
Top achievements
Rank 1
Answers by
Marin
Telerik team
Share this question
or