<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:InsideWyatt %>"
SelectCommand="SELECT Email, FirstName, LastName, Phone, Office, Image, RecordID FROM dropdown_qry WHERE (Image IS NOT NULL) ORDER BY LastName, FirstName">
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:InsideWyatt %>"
SelectCommand="SELECT [RecordID], [JobTitle], [Department], [Assistant], [OfficeStreet], [State], [Hired], [OfficeNumber], [Extension] FROM [qry_UserProfileList] WHERE ([RecordID] = @RecordID)">
<SelectParameters>
<asp:SessionParameter Name="RecordID" SessionField="RecordID" Type="Int64" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" GridLines="None" Skin="Outlook">
<
MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="RecordID">
<DetailTables>
<telerik:GridTableView runat="server"
DataSourceID="sqldatasource2" >
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="RecordID"
MasterKeyField="RecordID" />
</ParentTableRelation>
</telerik:GridTableView>
</DetailTables>
<
ExpandCollapseColumn Visible="True">
<
HeaderStyle Width="20px"></HeaderStyle>
</
ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="Email" HeaderText="Email"
SortExpression="Email" UniqueName="Email">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName"
SortExpression="FirstName" UniqueName="FirstName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="LastName" HeaderText="LastName"
SortExpression="LastName" UniqueName="LastName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Phone" HeaderText="Phone"
SortExpression="Phone" UniqueName="Phone">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Office" HeaderText="Office"
SortExpression="Office" UniqueName="Office">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Image" HeaderText="Image"
SortExpression="Image" UniqueName="Image">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="RecordID" DataType="System.Int64"
HeaderText="RecordID" SortExpression="RecordID" UniqueName="RecordID">
</telerik:GridBoundColumn>
</Columns>
</
MasterTableView>
</telerik:RadGrid>
Thank you.
Corey Hambrick