Binding a gridview with multiple table.

You can use this statement in your Query

SELECT c.Email, o.OrderTotal, orn.Note FROM tblCustomer c
INNER JOIN tblOrder o ON c.CustomerID = o.CustomerID
INNER JOIN tblOrderNote orn on o.OrderID = o.OrderID

As I getting you want o display Column datas from three different table in to one Gridview if so then you can use JOIN to bind data from multiple table to one gridview or even you can also use Merge method of Datable where Merge method is used specified DataTable with the current DataTable. otherwise
Try
Multiple Tables in one DataGridView[^]

HI arvind you have a query that states that select c,Email,o.Order.total.i gacve compleare the mainnptri so ckim 9).

hi,


Thanks to all for replying, the links provided by thatraja are very helpful to meet my requirement.

Hello sir,
Thank you for replying ..

would u pls provide some sample code in c#...

THANKS IN ADVANCE...

<pre><pre><pre><pre><pre><pre><code><code><code><code><code><code><code><code><code></code></code></code></code></code></code></code>code><pre><pre><pre><pre><pre>jj<pre><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small><small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small></small>

de>