Inner join sqldatasource when selecting data

[Nandkishor]

Hello ,

  I am using  telerick Ajax grid.

 I am to select data using in page data source , but i found plan queries in demo code. I want to select data using multiple tables with the help of inner join.

 please suggest.

 Thanks ,
Nandkishor.

[Princy]

Hello,

Here is an example which illustrate the same.
ASPX:

<telerik:RadGrid ID="radGrid1" runat="server"  AllowPaging="true"  DataSourceID="SqlDataSource1" AutoGenerateColumns="true" >
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" SelectCommand="SELECT Orders.CustomerID,Orders.OrderDate,Customers.ContactName,Customers.CompanyName FROM [Orders] inner join [Customers] ON Orders.CustomerID=Customers.CustomerID">
</asp:SqlDataSource>

Thanks,
Princy.