Hello. I'm trying to inner join two tables into one dataset. Is that possible. If so I do I do it. I have my code down below, so if you could help me. please!! I'm using asp.net for my coding
[vb.asp.net-code]
Dim myConnection As New Data.Odbc.OdbcC onnection(conne ctionstring)
Dim mysql As String = "select rmsfiles2.obcop 200.line#, rmsfiles2.mspmp 100.ptyp1, rmsfiles2.mspmp 100.ptyp2, rmsfiles2.obcop 200.quano, rmsfiles2.obcop 200.quana, rmsfiles2.obcop 200.quans, rmsfiles2.obcop 200.c2rdt,rmsfi les2.mspmp100.p rdno, rmsfiles2.obcop 200.unitm, rmsfiles2.mspmp 100.descp, rmsfiles2.obcop 200.actsp, rmsfiles2.obcop 200.ordno from rmsfiles2.obcop 200 inner join rmsfiles2.mspmp 100 on rmsfiles2.obcop 200.prdno = rmsfiles2.mspmp 100.prdno where rmsfiles.obcop2 00.ordno = " & Order.ToString( )
Dim command As New Data.Odbc.OdbcC ommand(mysql)
command.Connect ion = myConnection
Dim adapter As OdbcDataAdapter = New OdbcDataAdapter (command)
Dim ds As DataSet = New DataSet()
adapter.SelectC ommand = New OdbcCommandsele ct rmsfiles2.obcop 200.line#, rmsfiles2.mspmp 100.ptyp1, rmsfiles2.mspmp 100.ptyp2, rmsfiles2.obcop 200.quano, rmsfiles2.obcop 200.quana, rmsfiles2.obcop 200.quans, rmsfiles2.obcop 200.c2rdt,rmsfi les2.mspmp100.p rdno, rmsfiles2.obcop 200.unitm, rmsfiles2.mspmp 100.descp, rmsfiles2.obcop 200.actsp, rmsfiles2.obcop 200.ordno from rmsfiles2.obcop 200 inner join rmsfiles2.mspmp 100 on rmsfiles2.obcop 200.prdno = rmsfiles2.mspmp 100.prdno where rmsfiles.obcop2 00.ordno = " & Order.ToString( )
,myConnection)
adapter.Fill(ds , "rmsfiles2.OBCO P200, "MSPMP100")
gridview1.DataS ource = ds
gridview1.DataB ind()
[/code]
[vb.asp.net-code]
Dim myConnection As New Data.Odbc.OdbcC onnection(conne ctionstring)
Dim mysql As String = "select rmsfiles2.obcop 200.line#, rmsfiles2.mspmp 100.ptyp1, rmsfiles2.mspmp 100.ptyp2, rmsfiles2.obcop 200.quano, rmsfiles2.obcop 200.quana, rmsfiles2.obcop 200.quans, rmsfiles2.obcop 200.c2rdt,rmsfi les2.mspmp100.p rdno, rmsfiles2.obcop 200.unitm, rmsfiles2.mspmp 100.descp, rmsfiles2.obcop 200.actsp, rmsfiles2.obcop 200.ordno from rmsfiles2.obcop 200 inner join rmsfiles2.mspmp 100 on rmsfiles2.obcop 200.prdno = rmsfiles2.mspmp 100.prdno where rmsfiles.obcop2 00.ordno = " & Order.ToString( )
Dim command As New Data.Odbc.OdbcC ommand(mysql)
command.Connect ion = myConnection
Dim adapter As OdbcDataAdapter = New OdbcDataAdapter (command)
Dim ds As DataSet = New DataSet()
adapter.SelectC ommand = New OdbcCommandsele ct rmsfiles2.obcop 200.line#, rmsfiles2.mspmp 100.ptyp1, rmsfiles2.mspmp 100.ptyp2, rmsfiles2.obcop 200.quano, rmsfiles2.obcop 200.quana, rmsfiles2.obcop 200.quans, rmsfiles2.obcop 200.c2rdt,rmsfi les2.mspmp100.p rdno, rmsfiles2.obcop 200.unitm, rmsfiles2.mspmp 100.descp, rmsfiles2.obcop 200.actsp, rmsfiles2.obcop 200.ordno from rmsfiles2.obcop 200 inner join rmsfiles2.mspmp 100 on rmsfiles2.obcop 200.prdno = rmsfiles2.mspmp 100.prdno where rmsfiles.obcop2 00.ordno = " & Order.ToString( )
,myConnection)
adapter.Fill(ds , "rmsfiles2.OBCO P200, "MSPMP100")
gridview1.DataS ource = ds
gridview1.DataB ind()
[/code]
Comment