ADO.NET

Manipulate data with Command object


Using Command object to insert, delete, and update data

Insert data

Sub addnewimage(ByVal path As String, ByVal cn As OleDb.OleDbConnection, ByVal cmd As OleDb.OleDbCommand)
        'save image
        cmd = New OleDb.OleDbCommand("Insert Into tblimages(Path) Values('" & path & "')", cn)
        cmd.ExecuteNonQuery()
 
    End Sub
 


Delete data


Sub deleteimage(ByVal id As Integer, ByVal cn As OleDb.OleDbConnection, ByVal cmd As OleDb.OleDbCommand)
        'delete image
        cmd = New OleDb.OleDbCommand("Delete * From tblimages Where ID=" & id, cn)
        cmd.ExecuteNonQuery()
        'update listview
        Lstimages.Items.Remove(Lstimages.SelectedItems(0))
    End Sub


Update data


  Sub updateimage()
        'save image
        cmd = New OleDb.OleDbCommand("Update tblimages Set Path='" & txtpath.Text & "' Where ID=" & Form1.Lstimages.SelectedItems(0).Text, dbcon.connection)
        cmd.ExecuteNonQuery()     End Sub



HTML Comment Box is loading comments...



This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.