cmd Insert Data in vb.net

 ' code Insert ,Update, Delete
' Code connect Oracle

Connection Oracle Link
ConnectionOpen()
Dim custsInsCmd As OracleCommand
custsInsCmd = _Conn.CreateCommand() 
Dim sql = " update TBL_TABLE set " & _
                " NAME = 'abc' " & _
                " where ID = 1 "

custsInsCmd.CommandText = sql
custsInsCmd.ExecuteNonQuery()
ConnectionClose()

Read More

DataTable Update Data in vb.net

Connection Oracle Link

Dim da As OracleDataAdapter
Dim dt As New Data.DataTable("dt")
Dim strSQL As String = ""
strSQL = "SELECT * FROM TBL_TABLE where ID = '1'"
ConnectionOpen()
da = New OracleDataAdapter(strSQL, conn)
Dim SqldtSearch As OracleCommandBuilder = New OracleCommandBuilder(da)
dt.Columns.Clear()
dt.Rows.Clear()
da.Fill(dt)

' Edit Datatble Update  " Braaaaaa......."
da.Update(dt)

MsgBox("Save Complete !!!")
ConnectionClose()

Read More