how do I inner join two table to a dataset

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kjewell23
    New Member
    • Sep 2007
    • 49

    #1

    how do I inner join two table to a dataset

    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]
    Last edited by kjewell23; Sep 24 '07, 05:43 PM. Reason: forgot to say what code and more editing
  • davef
    New Member
    • Sep 2007
    • 98

    #2
    While you can do it for selection and databinding purposes, I don't believe such a dataset will let you perform update/insert operations.

    Comment

    • kjewell23
      New Member
      • Sep 2007
      • 49

      #3
      I'm not going to update or insert. I'm just binding the two table together
      Originally posted by davef
      While you can do it for selection and databinding purposes, I don't believe such a dataset will let you perform update/insert operations.

      Comment

      Working...