VB.NET tutorial: Manipulate data with Command object

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






Comments

Name:
Comment:
Enter the text:
CAPTCHA image

....................................................................................................................Home | Forum | About | Contact
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.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.
Home Programming Web DB & App Questions Exercises Tips Programs FAQs Download About
Computer-Wbest
Popular Pages
You might like