insert data it give error

[sadia644]

can anyone tell me OLEDB connection i creat connection but when i try to insert data it give error on nonQuery i m using Visual studio 2008...
insert,update,delete and i want to retrive data
can any one provide me helping material books,note etc related to this topic
thanks

 

[sadia644]

how it can b declare....

 

[InertiaM]

how it can b declare....

Dim command As New SqlCommand(SqlStr, myConnection)
command.Parameters.Add(New SqlParameter("@Emp_Name", SqlDbType.VarChar, 30))
Command.Parameters("@Emp_Name").Value = "Bob"
...
(or)
...
command.Parameters.AddWithValue("@Emp_Id", 25)

command.ExecuteNonQuery()