How to get columns from two different tables

Question

How to get columns from two different tables with unmatched column first query; select * from PriceBreakupSaleBuyBack where itemNumber=@itemNumber second query select G_from G_To  value from MarkupSlab where Group='G' if there any idea that i can use both query at same time. or in same connection and command.

Dharmraj Thakur · Answer

Just execute these two queries and get result in DataSet object. DataSet can hold multiplet tables. You can read one by one like this... DataSet ds = new DataSet(); SqlDataAdapter adp = new SqlDataAdapter(query conn); adp.Fill(ds); ds.Tables[0].TableName = Table1 ; ds.Tables[1].TableName = Table2 ; if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { // you will get all rows like this item[ Id ].ToString(); } } if (ds != null && ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0) { foreach (DataRow item in ds.Tables[1].Rows) { // you will get all rows like this item[ Id ].ToString(); } }

Amit Kumar · Answer

Hi SK can u provide a tables structure. ?

Altaf Ansari · Answer

Try this Query : SELECT tA.itemNumber tB.G_fromtB.G_To FROM PriceBreakupSaleBuyBack tA OUTER JOIN MarkupSlab tB WHERE tA.itemNumbe=@itemNumber AND tB. Group = 'G'

Laxmidhar Sahoo · Answer

sir you may use sqldataadapter class that the object of adaptor class call the fill method with dataset parameter like ada.fill(ds) ; then get var d1 = ds.tables[0]; var d2 = ds.tables[1]; when both the query fire in a stored procedure separated by ;

Sagar Shinde · Answer

Please refer below link- https://www.codeproject.com/Articles/306722/Executing-multiple-SQL-statements-as-one-against-S