DataGrid
-
Hello I have to different tables. I want to Display both tables data on one datagrid. Is that possible. If yes then plz tell me how. Thankx in Advance.
-
Hello I have to different tables. I want to Display both tables data on one datagrid. Is that possible. If yes then plz tell me how. Thankx in Advance.
Hope this will help you http://www.dotnetbips.com/articles/displayarticledetails.aspx?articleid=94[^]
Regards, Sylvester G Senior Software Engineer Xoriant Solutions sylvester_g_m@yahoo.com
-
Hope this will help you http://www.dotnetbips.com/articles/displayarticledetails.aspx?articleid=94[^]
Regards, Sylvester G Senior Software Engineer Xoriant Solutions sylvester_g_m@yahoo.com
Thank u very much but sir i have two different tables. One Table may have less rows then the other. However One table primary key is included in the other. Tables Structur Cust_Order(Order_Id, cust_id, Date...) Cust_Debit(Debit_No, Order_Id, ......) Is that possible to Display boths Data on Same Datagrid. Cust_Debit may have 0 or less records then Cust_Order. Please Help Thanks in Advance.
-
Thank u very much but sir i have two different tables. One Table may have less rows then the other. However One table primary key is included in the other. Tables Structur Cust_Order(Order_Id, cust_id, Date...) Cust_Debit(Debit_No, Order_Id, ......) Is that possible to Display boths Data on Same Datagrid. Cust_Debit may have 0 or less records then Cust_Order. Please Help Thanks in Advance.
In the select query itself you can use joins, If you dont want to miss records from Cust_Order then use the following join Select From Cust_Order Left Outer Join Cust_Debit On Cust_Order.Order_Id=Cust_Debit.Order_Id If you dont want to miss records from Cust_Debit then use the following join Select From Cust_Order Right Outer Join Cust_Debit On Cust_Order.Order_Id=Cust_Debit.Order_Id If you dont want to miss records from both Cust_Order and Cust_Debit then use the following join Select From Cust_Order Full Outer Join Cust_Debit On Cust_Order.Order_Id=Cust_Debit.Order_Id Regards, Sylvester G Senior Software Engineer Xoriant Solutions sylvester_g_m@yahoo.com
-
Hello I have to different tables. I want to Display both tables data on one datagrid. Is that possible. If yes then plz tell me how. Thankx in Advance.
You can use hierarchical grid. show debt part in child row.
-
You can use hierarchical grid. show debt part in child row.
I used the following query but it display records twice.Means repeating. It should not be. SELECT cust_order.order_id, cust_order.order_date, cust_order.order_status, cust_order.lock_status, Cust_debit.Debit_Id FROM cust_order, Cust_debit WHERE Cust_debit.Cust_Id = " & cust_id & " and cust_order.customer_id = " & cust_id whre cust_id is customer_id. Please help
-
I used the following query but it display records twice.Means repeating. It should not be. SELECT cust_order.order_id, cust_order.order_date, cust_order.order_status, cust_order.lock_status, Cust_debit.Debit_Id FROM cust_order, Cust_debit WHERE Cust_debit.Cust_Id = " & cust_id & " and cust_order.customer_id = " & cust_id whre cust_id is customer_id. Please help
create a join between cust_order.order_id = cust_debit.Cust_id
-
Hello I have to different tables. I want to Display both tables data on one datagrid. Is that possible. If yes then plz tell me how. Thankx in Advance.
use like this Select From Cust_Order Inner Join Cust_Debit On Cust_Order.Order_Id=Cust_Debit.Order_Id where Cust_Order.Order_Id = Regards, Sylvester G Senior Software Engineer Xoriant Solutions sylvester_g_m@yahoo.com