🔒 Closed Need help vb2010 ordering

[Saycheeseter]

Guys pa help naman po ako dto sa system ko sa sunday na po deadline eh. ung pag nag order po ako lahat mapupunta sa listview pero po ang nangyayare napupunta nga lahat sa listview pero pag sinave ko isa lang nasasave hindi kasama ung iba.

 

[ibyong]

try nyo mag search sa google ng mga sample query para sa multiple add from listview to database

 

[Mrkmrk]

Show your code para malaman namin kung pano ka tutulungan.

 

[Saycheeseter]

Try
For Each item As ListViewItem In LV.Items
str = "INSERT INTO ordering ([Name],[Phone],[Description],[Quantity],[Price],[Total]) values (?,?,?,?,?,?)"
Dim cmd As OleDbCommand = New OleDbCommand(str, Con)
cmd.Parameters.AddWithValue("name", txtname.Text)
cmd.Parameters.AddWithValue("phone", txtphone.Text)
cmd.Parameters.AddWithValue("@Description", item.Text)
cmd.Parameters.AddWithValue("@Quantity", item.SubItems(1).Text)
cmd.Parameters.AddWithValue("Price", item.SubItems(2).Text)
cmd.Parameters.AddWithValue("@Tota;", item.SubItems(3).Text)

cmd.ExecuteNonQuery()
cmd.Dispose()
MsgBox("Successfully")


Next

Catch ex As Exception

MessageBox.Show(ex.ToString)

End Try


eto po code ko para sa save button mga sir.

 

[Mrkmrk]

Iloop mo yung insert function mo. ex:

For index as Integer = 0 to Listview1.items.count step 1
 con.open()
 str = "INSERT INTO ordering (name,.....) VALUES (@name, .....)"
 Dim cmd as OleDbCommand = New OleDbCommand(str, Con)
 cmd.Parameters.AddWithValue("@name", txtname.Text)
...... // Jump na ko sa quantity
 cmd.Parameters.AddWithValue("@Quantity", item.SubItems(index).Text)
 cmd.Parameters.AddWithValue("@Price", item.SubItems(index).Text)
 cmd.Parameters.AddWithValue("@Total", item.SubItems(index).Text)

cmd.ExecuteNonQuery();

con.close()

Next

Note: ginaya ko lang code mo, dinagdagan ko lang ng for loop, tapos yung parameter ng SubItems() ginawa kong variable na index (yung nasa for loop). Then lagi mo icclose yung connection every insert.

Ps. Not sure kung working to. Di ko naman kasi natry hahaha but the idea is there, explore mo nalang