Insert in Access threw typed dataset Tableadapter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After creating the typed dataset , i've created the wanted sql functions in
the .xsd file. Now i'm trying to enter the data into database threw the
insert query that was automaticly created by .net .
Must add that in the access itself the sql query work , so i'm pretty sure
that the syntax is correct.
Also the fill of the datatables does work , so the connection to the
database is also right.
Insert into 'tablename' ('col1','col2') values (?,?) - was created by .net
at the beggining. after testing the query at access it worked when i've
changed it to:
Insert into 'tablename' ('col1','col2') values (col1,col2) - and actually
entered the data into database.
The data wouldn't enter.
Are there any more adjustment i have to do?
 
TzvikaDotNet said:
After creating the typed dataset , i've created the wanted sql functions
in
the .xsd file. Now i'm trying to enter the data into database threw the
insert query that was automaticly created by .net .
Must add that in the access itself the sql query work , so i'm pretty sure
that the syntax is correct.
Also the fill of the datatables does work , so the connection to the
database is also right.
Insert into 'tablename' ('col1','col2') values (?,?) - was created by .net
at the beggining. after testing the query at access it worked when i've
changed it to:
Insert into 'tablename' ('col1','col2') values (col1,col2) - and actually
entered the data into database.
The data wouldn't enter.
Are there any more adjustment i have to do?
Click to expand...

What do you mean by "The data wouldn't enter."?
Did you get some sort of error message? If so, please quote.
 
Back
Top