how to add, delete, search and view data

[slapshock]

hi....can u help me with my problem???

i need the codes on how add, delete, search and view data from listview in vb.net...
hope you can help me...
i am new in .NET...and i dont know how to do it

[Aneri]

If oracle is used as back-end then

In .NET datagrid is generally used to view data
btnadd is a Button control
oraconnection1 is name given to OracleConnection
pt is declared as datatable


for ADD
Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click
Dim str1 As String
str1 = "insert into tablename(emp_no)values('"&txt1.Text&"')"
Dim cmd2 As New OracleClient.OracleCommand(str1, oraconnection1)
If oraconnection1.State = ConnectionState.Closed Then
oraconnection1.Open()
cmd2.ExecuteNonQuery()
oraconnection1.Close()

similarly,for DELETE

replace str1 with

str1 = ""delete from tablename where condition"

for VIEW,

Dim str As String
str = "select columname from tablename"
Dim cmd As New OracleClient.OracleCommand(str, oraconnection1)
Dim ad1 As New OracleClient.OracleDataAdapter(cmd)
pt.Clear()
ad1.Fill(pt)
oraconnection1.Close()
DataGrid1.DataSource = pt
DataGrid1.DataBind()