How to insert multiple rows of data from listview to linq to sql VB.Net

Question

i'm a newbie in programming vb.net, I'm making a simple point of sale I want to insert multiple rows of data from listview to linq to sql, here is the code:

Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click

    Dim db As New PenjualanDataContext
    For Each item As ListViewItem In ListView1.SelectedItems
        Dim TransaksiBaru As New Transaksi With {.Dibayar = Dibayar.Text, .Faktur = FakturTextBox.Text, .Harga = HargaComboBox.Text, .Jumlah = JumlahTextBox.Text, .Kembali = Kembali.Text, .Kode_Barang = Kode_BarangComboBox.Text, .Nama_Barang = Nama_BarangComboBox.Text, .SubTotal = SubTotalTextBox.Text, .Tanggal = TanggalDateTimePicker.Text, .Total = TotalTextBox.Text}
        db.Transaksis.InsertOnSubmit(TransaksiBaru)
        db.SubmitChanges()
    Next

End Sub

I cannot save the data to linq to sql.....

I cannot save the data to linq to sql. That can mean anything. Please be more specific. — Gert Arnold
– Gert Arnold, Commented Apr 2, 2017 at 11:55

Hadi · Accepted Answer · 2017-04-02 08:13:27Z

2

First, it is faster to Submit Changes one time when all record are inserted in the context.

Second, it is recommended to use Using method

Third, you are looping over ListView1.SelectedItems and not using item object returned by the loop. i think that you are missing something in your code

Try modifying your code to the following:

Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click

    Using db As New PenjualanDataContext

        For Each item As ListViewItem In ListView1.SelectedItems

            Dim TransaksiBaru As New Transaksi With {.Dibayar = Dibayar.Text, .Faktur = FakturTextBox.Text, .Harga = HargaComboBox.Text, .Jumlah = JumlahTextBox.Text, .Kembali = Kembali.Text, .Kode_Barang = Kode_BarangComboBox.Text, .Nama_Barang = Nama_BarangComboBox.Text, .SubTotal = SubTotalTextBox.Text, .Tanggal = TanggalDateTimePicker.Text, .Total = TotalTextBox.Text}

            db.Transaksis.InsertOnSubmit(TransaksiBaru)

        Next

         db.SubmitChanges()

     End Using

End Sub

You can refer to the following MSDN article to read more about inserting Rows using Linq-to-SQL

answered Apr 2, 2017 at 8:13

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

har07 Over a year ago

To OP: You should be populating properties of Transaksi from item..

Puji Leksana Over a year ago

Wow, it works, thanks Hadi, you' re a big help!!! And if I want to print the listview data, can I be able to use Using Method also?

Hadi Over a year ago

Happy to help. Yes you can use it. If this answer worked you have to accept it else give me a feedback

Collectives™ on Stack Overflow

How to insert multiple rows of data from listview to linq to sql VB.Net

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related