Re: Insert in Access threw typed dataset Tableadapter
- From: "pvdg42" <pvdg42@xxxxxxxxxxxxxxxxx>
- Date: Mon, 20 Nov 2006 06:48:56 -0600
"TzvikaDotNet" <TzvikaDotNet@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A2E66709-FBB1-42D0-9838-04379DD0E5DE@xxxxxxxxxxxxxxxx
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?
What do you mean by "The data wouldn't enter."?
Did you get some sort of error message? If so, please quote.
.
- Prev by Date: Re: Oracle
- Next by Date: Trouble displaying info from access db
- Previous by thread: Oracle
- Next by thread: Trouble displaying info from access db
- Index(es):
Relevant Pages
|
Loading
