Save a virtual table to a SQL Table

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • tnks

    Save a virtual table to a SQL Table

    Hello

    i need to save a virtual table (dataset table) into a SQL table
    somo one know how to do it ??

    (this is part of my code)

    Dim sqladapt As SqlDataAdapter
    Dim dsOC As New DataSet
    Dim dt As New DataTable
    Dim sqlcon As New SqlConnection(G eneral.Connecti onString)

    Dim sqlcom As New SqlCommand("sel ect a.wring, a.ClaveWring, a.descripcion,
    a.pedido, b.UnidadMedida1 , b.unidadEmpaque 1, b.PrecioPorEmpa que3 from
    OrdenCompra_det ail a join CatalogoWrings b on b.id_wring = a.clavewring where
    ID_ordencompra = @oc", sqlcon)

    Dim dgTabStyle As New DataGridTableSt yle
    Dim dcpaquete As New System.Data.Dat aColumn("Paquet es")
    dcpaquete.DataT ype = System.Type.Get Type("System.In t32")
    Dim dcunidad As New System.Data.Dat aColumn("Unidad es")
    dcunidad.DataTy pe = System.Type.Get Type("System.In t32")
    sqlcon.Open()

    sqlcom.Paramete rs.Add("@oc", SqlDbType.Int). Value = 5
    sqladapt = New SqlDataAdapter( "", sqlcon)
    sqladapt.Select Command = sqlcom
    dsOC.Clear()
    sqladapt.Fill(d sOC, "Compras")
    dsOC.Tables("Co mpras").Columns .Add(dcpaquete)
    dsOC.Tables("Co mpras").Columns .Add(dcunidad)
    dt = dsOC.Tables("Co mpras")
    DgResumen.DataS ource = dsOC.Tables("Co mpras")

    =============== ============
    i need to save the "compras" table to "Order_Deta il" (an sql table in my
    database)


Working...