I donno why, but I cannot add record in the DataGrid with the following code.


Cnn.Execute ("create table [Table1] " & _ "
(Field1 INT,Field2 DateTime,Field3 VarChar(8000))")

Adodc1.ConnectionString = Cnn.ConnectionString
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select * from [Table1]"
Adodc1.Refresh

DataGrid1.DataSoruce = Adodc1

When I try to add a row in it
it will have a not fatal error message
"The current row is not available"

What is this mean?
Thanks