database files (DBFs)

[Marco Wolff]

hello,

i have to work with dbf - files and want to read a dbf - file in a dataset,
insert new rows und then update the dataset.

i can fill a DataAdapter over a odbc-driver. but i get always an exception
when i try to get insert-, update- and delete-commands over a
commandBuilder.

have somebody experience with dbf-files and can help me?

thanks

 

[Patrice]

Never tried with DBF but letting us know what is the exception you have
would be perhaps a starting point ?

Patrice

 

[Guest]

DBF files use temp files to enable multiuser access to the file like Access
does.

If this is ASP.NET then it may be permissions required in the ASPNET user's
temp directory.

 

[Marco Wolff]

after i filled my ObdcAdapter with the dbf-file i ask the commandBuilder
for the insert-, update- und deleteCommands and he says that he can`t
create the commands because the select command gives not enough
information about the columns inside the dbf-file.

 

[William \(Bill\) Vaughn]

I suggest you take a look at my article on the Command(don't use)Builder.
See www.betav.com\articles.htm


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Patrice]

It likely misses a primary key...

Patrice

 

[Marco Wolff]

yes, that`s the reason.

now i created the commands self and the programm is running.

the problem is, that a dbf-file does not support a primary key.

 

[Patrice]

That's really old but if I remember the ODBC driver is able to use a text
file that describes the DBF fields...

Anyway if it's running now with your own command....

Patrice

--