How to get columns from two different tables

Sk Jha

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.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar8y ago
Hi,
SK can u provide a tables structure. ?
0
Altaf Ansari8y ago
Try this Query :
SELECT
tA.itemNumber, tB.G_from,tB.G_To
FROM PriceBreakupSaleBuyBack tA
OUTER JOIN MarkupSlab tB
WHERE tA.itemNumbe=@itemNumber AND tB.Group='G'
0
Dharmraj Thakur8y ago
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();
    }
}
+1
Laxmidhar Sahoo8y ago
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 ;
0
Sagar Shinde8y ago
Please refer below link-
https://www.codeproject.com/Articles/306722/Executing-multiple-SQL-statements-as-one-against-S
0