Porque no ingresa los datos????

[jasamestica]

Porque no se insertan los datos a la tabla de la bd si uso el objeto ocomandoinsercion de tipo sqlcommand

Dim oConexion As New SqlConnection
Dim oDataAdapter As New SqlDataAdapter()
Dim oDataSet As New DataSet()

oConexion.ConnectionString = "server=(local);database=mibase;uid=sa;pwd=;"

Dim ocomandoselect As New SqlCommand("SELECT * FROM cliente", oConexion)
oDataAdapter.SelectCommand = ocomandoselect
Dim ocomandoinsercion As New SqlCommand("INSERT INTO cliente(codcliente,nombre,apellido) VALUES(7,7,7)", oConexion)
oDataAdapter.InsertCommand = ocomandoinsercion
oConexion.Open()
oDataSet.Clear()