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

Select Data Reader in vb.net

ConnectionOpen()
Dim cmd As New OracleCommand
Dim dr As OracleDataReader
dim str as String 
Dim sql= "SELECT * FROM TBL_TABLE where ID = '1'"
cmd = New OracleCommand(sql, conn)
dr = cmd.ExecuteReader
If dr.HasRows Then
       dr.Read()
       str = dr("NAME").tostring
End If
ConnectionClose()

Read More