Tampilkan postingan dengan label DataSet. Tampilkan semua postingan
Tampilkan postingan dengan label DataSet. Tampilkan semua postingan

programmatically Insert Row To DataSet

Posted On // Leave a Comment
Jika kita ingin menambahkan baris data kedalam DataSet pada Visual Basic .NET dengan menggunakan Kode, berikut adalah script nya.

Kita asumsikan bahwa Anda telah mempunyai DataSet DS yang berisi DataTable bklPKBDetail

Dim _dr As DataRow
_dr = DS.bklPenjualanDetail.NewRow


_dr("Nomor") = TEJualNomor.EditValue
_dr("PKBNomor") = TEPKBNomor.EditValue
_dr("Baris") = i
_dr("Jenis") = 1
_dr("ID") = 1
_dr("Kuantitas") = 1
_dr("HargaSatuan") = 1
_dr("Gross") = 1

DS.bklPenjualanDetail.Rows.Add(_dr)

[Read more]

How To Add 2 Relations to dataset ?

Posted On // Leave a Comment



I have two dataadapter in one dataset as shown.
1st dataset named "tblMaster"
2nd dataset named "tblDetail"



i use code below to create relations by Type Column (A)

Dim KeyPriTipe As DataColumn = dsRencanaAlokasi.Tables("tblMaster").Columns("Type")
Dim keyForTipe As DataColumn = dsRencanaAlokasi.Tables("tblDetail").Columns("Type")
dsRencanaAlokasi.Relations.Add("Detail", KeyPriTipe, keyForTipe, False)


 how can i add more relations (B) to dataset so the datasets linked by two relations, Type and Color?


''=======================================================================
i got my answer by myself. Array is the answer. heres the single code:



dsRencanaAlokasi.Relations.Add("NewRelation", New DataColumn() {dsRencanaAlokasi.Tables("Master").Columns("Tipe"), dsRencanaAlokasi.Tables("Master").Columns("Warna")}, _
                                                     New DataColumn() {dsRencanaAlokasi.Tables("Detail").Columns("Tipe"), dsRencanaAlokasi.Tables("Detail").Columns("Warna")})
[Read more]

Adding a DataTable to a DataSet

Posted On // Leave a Comment

Dim customerOrders As DataSet = New DataSet("CustomerOrders")

Dim ordersTable As DataTable = customerOrders.Tables.Add("Orders")

Dim pkOrderID As DataColumn = ordersTable.Columns.Add( _
    "OrderID", Type.GetType("System.Int32"))
ordersTable.Columns.Add("OrderQuantity", Type.GetType("System.Int32"))
ordersTable.Columns.Add("CompanyName", Type.GetType("System.String"))

ordersTable.PrimaryKey = New DataColumn() {pkOrderID}
sumber : http://msdn.microsoft.com
[Read more]

VB.NET Menambahkan 2 DataAdapter kedalam 1 DataSet

Posted On // Leave a Comment
Dim dataSetSublet As New DataSet
        Dim dataAdapterSubletHeader As SqlDataAdapter = New SqlDataAdapter("SELECT ID,Nama FROM OPQHeader", _SqlConnection) 'Tanggal,Nomor,PONomor,PKBNomor FROM sblPembelian", _SqlConnection)
        Dim dataAdapterSubletDetail As SqlDataAdapter = New SqlDataAdapter("SELECT HeaderID,Nama FROM OPQDetail", _SqlConnection) ',Baris,SubletID,Kuantitas,HargaSatuan FROM sblPembelianDetail", _SqlConnection)

        dataAdapterSubletHeader.Fill(dataSetSublet, "Header")
        dataAdapterSubletDetail.Fill(dataSetSublet, "Detail")

        Dim KeyColumnNomor As DataColumn = dataSetSublet.Tables("Header").Columns("ID")
        Dim KeyForeignColumnNomor As DataColumn = dataSetSublet.Tables("Detail").Columns("HeaderID")
        dataSetSublet.Relations.Add("RelationSubletMasterDetail", KeyColumnNomor, KeyForeignColumnNomor, False)

        GridControl1.DataSource = dataSetSublet.Tables("Header")
        CardView1.PopulateColumns(dataSetSublet.Tables("Detail"))
[Read more]