S
Surya
Dear All,
I have problem on inserting a record to database..Although it looked
easy.. i have caught up with following issue .. please go ahead and
help me to find solution
I Need to insert records to a data base,for which i am using Typed
dataSet.(I used DataSet Designer to create one)
Then created a table adapter in which i have written query for
INSERT , & set Database Direct property to true.(I didnt use a
seperate methods for INSERT,instead used inbuilt )
query......>INSERT INTO TABLE1 (NAME,CITY) VALUES (?,?)
Then in My .Vb file i called this method as
Adapter1.Insert("Value1",Value2").. before that
i used Adapter1.connection.open() and Adapter1.connection.close after
that insert ., explicitly.
For the Insert button coding...
Although it compiles and executes Fine .. record is not inserted.to
database Please clarify what I have been missing
I am using Visual studio 2005 & Access 2003
Thanks in advance,
Surya
I have problem on inserting a record to database..Although it looked
easy.. i have caught up with following issue .. please go ahead and
help me to find solution
I Need to insert records to a data base,for which i am using Typed
dataSet.(I used DataSet Designer to create one)
Then created a table adapter in which i have written query for
INSERT , & set Database Direct property to true.(I didnt use a
seperate methods for INSERT,instead used inbuilt )
query......>INSERT INTO TABLE1 (NAME,CITY) VALUES (?,?)
Then in My .Vb file i called this method as
Adapter1.Insert("Value1",Value2").. before that
i used Adapter1.connection.open() and Adapter1.connection.close after
that insert ., explicitly.
For the Insert button coding...
Although it compiles and executes Fine .. record is not inserted.to
database Please clarify what I have been missing
I am using Visual studio 2005 & Access 2003
Thanks in advance,
Surya