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)
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)