C# tutorial- Command object to manipulate data

Command object to manipulate data

Insert data

 private void addnewimage(string path, OleDbConnection cn, OleDbCommand cmd){

        //save image

        cmd = new  OleDbCommand("Insert Into tblimages(Path) Values('" + path + "')", cn)

        cmd.ExecuteNonQuery();

    }

Delete data

private void deleteimage(int id,  OleDbConnection cn,  OleDbCommand cmd){

        //delete image

        cmd = new OleDb.OleDbCommand("Delete * From tblimages Where ID=" + id, cn);

        cmd.ExecuteNonQuery();

        //update listview

        Lstimages.Items.Remove(Lstimages.SelectedItems[0]);

    }

Update data

private void updateimage(OleDbConnection cn,  OleDbCommand cmd){

        //update image

        cmd = new OleDbCommand("Update tblimages Set Path='" + txtpath.Text +"' Where ID=" + Form1.Lstimages.SelectedItems[0].Text,cn);

        cmd.ExecuteNonQuery();

    }