<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AllowSorting="True" DataSourceID="ds_MainGrid" GridLines="None"
Skin="WebBlue" Width="1025px" AutoGenerateColumns="False"  AllowAutomaticUpdates="True" ShowStatusBar="True" ShowFooter="True" >
<HeaderContextMenu EnableAutoScroll="True">
</HeaderContextMenu>
<MasterTableView DataSourceID="ds_MainGrid" DataKeyNames="ID" ClientDataKeyNames="ID" EditMode="InPlace" >
<Columns>
<telerik:GridTemplateColumn UniqueName="TemplateEditColumn">
<ItemTemplate>
<asp:Button ID="btn_Row_Options" runat="server" Text="Options" />
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn DataField="ID" HeaderText="ID" SortExpression="ID" UniqueName="ID">
<EditItemTemplate>
<asp:TextBox ID="IDTextBox" runat="server" Text='<%# Bind("ID") %>' Width="27px" ></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="IDLabel" runat="server" Text='<%# Eval("ID") %>' Width="27px"></asp:Label>
</ItemTemplate>
<HeaderStyle Width="20px" HorizontalAlign="Center" />
<ItemStyle Width="20px" />
</telerik:GridTemplateColumn>
</Columns>
</MasterTableView>
<ClientSettings AllowColumnsReorder="True"  >
<ClientEvents OnCommand="grid_Command" /> 
</ClientSettings>
</telerik:RadGrid>

   
<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
<script type="text/javascript">
function grid_Command(sender, eventArgs)
{
   alert('testing');
}
</script>
</telerik:RadCodeBlock>

void ExportGridView()

{

Response.Clear();

Response.AddHeader(

"content-disposition", "attachment;filename= Report.xls");

Response.Charset =

"";

Response.ContentType =

"application/vnd.ms-excel";

System.IO.

StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.

HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

Page pg = new Page();

pg.EnableEventValidation =

false;

pg.DesignerInitialize();

HtmlForm frm = new HtmlForm();

pg.Controls.Add(frm);

frm.Attributes.Add(

"runat", "server");

frm.Controls.Add(pnlUser); // Adding panel to form

I must be having stuck in the fog. I know what I am asking is simple however I cannot see the solution.

I am trying to display data in a RADGrid that include associated information between two tables.

I have two tables Products and Vendors

Products                                         Vendors

ProductID (pk)                                  VendorID (pk)

ProductName                                    VendorName

VendorRef (fk)

I want to display information from the products table including the VendorName from the vendors table.

Thank you for any insight and assistance.

Ray