Please help me in VB 6.0 !?

Question

i want to insert a record in a table with ADO ,and i wrote this code:
------------------------------------------------------------------------
Private Sub Command1_Click()
ado1.recordsource="insert into table1 values('a','b')"
ado1.refresh
End Sub
------------------------------------------------------------------------
but in run_time i see this error:
operation is not allowed when
the object is closed.
what can i do.

Answer 1

you should read about data and adodc property and if you working with code only you have to declare with starting of form with
dim RS as recordset
dim cn as connection

then in your programming wherever you want to execute your code write
set rs = new recordset
set cn = new connection
then you have to write a connection string and then you can your query

Answer 2

use "Execute" method of Connection object.
connection is a part of ADO control.

ADO1.CONNECTION.EXECUTE("insert into table1 values('a','b')")

Answer 3

You have at first to open the Recordset
ado1.open
ado1.Add
ado1.field1 = 'a'
ado1.field2 = 'b'
ado1.update
ado1.refresh
adp1.close

Helmut