save listview data in mysql query browser database

Question

    Dim lvitem As Object
    Dim iCount As Integer
    Dim iLoop As Integer
    Dim query3 = New SqlCommand
    query3.Connection = New SqlConnection("SERVER=localhost;UID=root;DATABASE=test;")
    iCount = lvLogs.Items.Count()
    If Not lvLogs.Items.Count = 0 Then
        Do Until iLoop = lvLogs.Items.Count
            lvitem = lvLogs.Items.Item(iLoop)
            With LvItem
                query3.CommandText = "insert into wer(CustomerName,SalesGroup,CustomerType,TypeOfIndustry,RM,SeniorRM) values('" & .SubItems(0).Text & "','" & .SubItems(1).Text & "','" & .SubItems(2).Text & "','" & .SubItems(3).Text & "','" & .SubItems(4).Text & "','" & .SubItems(5).Text & "')"
                query3.ExecuteNonQuery()
            End With
            iLoop = iLoop + 1
            LvItem = Nothing
        Loop
    End If
    MessageBox.Show("Record Saved!")

That is my code. message box show up but the record is not saved in my database. please help me

KV Prajapati · Accepted Answer · 2011-11-17 03:16:46Z

1

You can't use SqlClient provider. You must have to use MySql .net connector API and take a look at MySql connector examples.

edited Nov 17, 2011 at 3:16

answered Nov 17, 2011 at 3:10

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

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

2 Comments

Sigrid Ann Omila Over a year ago

where can i find it? what should i click?

KV Prajapati Over a year ago

@SigridAnnOmila - Click on the links I've pasted in my post.

Collectives™ on Stack Overflow

save listview data in mysql query browser database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related