datagridview - give me a same code for deleting purposes..vb.net 2010 - closed -

the code below code saving records

provider = "provider=microsoft.ace.oledb.12.0;data source ="         'change following access database location         datafile = "c:\users\dell\downloads\windowsapplication1\windowsapplication1\database1.accdb"         connstring = provider & datafile         myconnection.connectionstring = connstring         myconnection.open()         dim str string         str = "insert tblodr ([id], [office], [elements], [objectives], [initiatves]) values (?, ?, ?, ?, ?)"         dim cmd oledbcommand = new oledbcommand(str, myconnection)         cmd.parameters.add(new oledbparameter("id", ctype(idtextbox.text, string)))         cmd.parameters.add(new oledbparameter("office", ctype(officetextbox.text, string)))         cmd.parameters.add(new oledbparameter("elements", ctype(elementstextbox.text, string)))         cmd.parameters.add(new oledbparameter("objectives", ctype(objectivestextbox.text, string)))         cmd.parameters.add(new oledbparameter("initiatves", ctype(initiatvestextbox.text, string)))          try              cmd.executenonquery()             cmd.dispose()             myconnection.close()             me.validate()             me.tblodrbindingsource.endedit()             me.tblodrtableadapter.update(me.database1dataset.tblodr)         catch ex exception             msgbox(ex.message)         end try 

can give me same code but, deleting purposes.. code above adds new record , shows instantly in datagridview after adding it..(before have code adding purposes wont add instantly in datagridview).. want is, code when delete record using textbox (i'm deleting records inputting id number of record in textbox)..the deleted record show instantly after deleting it.. (my code of now, when delete record, delete record have close form , run program again show if deleted record have been deleted)

you can use gridview1.refresh() method refresh grid on delete button , when delete common executes, refresh gridview update new record use gridview1.update() update changes have made. or can make own method refresh gridview,here sample method refresh grid

public sub gridrefresh(byval s string, byval dgv datagridview)     dim dt new datatable()     dim cmd new sqlcommand("select *  " + s + "", con.dbconnection())     cmd.commandtype = commandtype.text     dim da new sqldataadapter(cmd)     da.fill(dt)     dgv.datasource = dt end sub 

here s represent name of table , when call method u can use gridrefresh("name of table ",datagridview1 name ), hope you