Loading

how to show data using two table in c# .net

Swapnil S

how display data using two table i am use one text box and one button and one datagrideview and two table i am use following query SqlDataAdapyer asdf= new sqldataadapter("select * from sem1,sem2 wher cid=''"+textbox1.text+"",con); datatable dt = new datatable; dt.Fill(dt); Gridviewer.datasource=dt; but data show only sem1 in datagrideview.

1 Reply

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

Suraj Kumar8y ago
Hello Swapnil,

You can use inner join or left join or union to show both table as shown below
select * from sem1
inner join sem2 on sem1.cid = sem2.cid

or

select * from sem1
left join sem2 on sem1.cid = sem2. cid

or

select * from sem1
union
select * from sem2
It will show the records from both the table. You can add where condition also in above query.
0