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

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

Patrice

--

"Marco Wolff" <(E-Mail Removed)> a écrit dans le message de
news:eA4eH%23X%(E-Mail Removed)...
> 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
>
>

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.

"Patrice" wrote:

> Never tried with DBF but letting us know what is the exception you have
> would be perhaps a starting point ?
>
> Patrice
>
> --
>
> "Marco Wolff" <(E-Mail Removed)> a écrit dans le message de
> news:eA4eH%23X%(E-Mail Removed)...
> > 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
> >
> >
>
>
>

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.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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.
__________________________________

"Marco Wolff" <(E-Mail Removed)> wrote in message
news:%23dHMjKa%(E-Mail Removed)...
>
> 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.
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

It likely misses a primary key...

Patrice

--

"Marco Wolff" <(E-Mail Removed)> a écrit dans le message de
news:%23dHMjKa%(E-Mail Removed)...
>
> 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.
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

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" <(E-Mail Removed)> schrieb im Newsbeitrag
news:ek8Zzsh%(E-Mail Removed)...
> It likely misses a primary key...
>
> Patrice
>
> --
>
> "Marco Wolff" <(E-Mail Removed)> a écrit dans le message de
> news:%23dHMjKa%(E-Mail Removed)...
>>
>> 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.
>>
>>
>>
>> *** Sent via Developersdex http://www.developersdex.com ***
>> Don't just participate in USENET...get rewarded for it!
>
>

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

--

"Marco Wolff" <(E-Mail Removed)> a écrit dans le message de
news:eq7in9h%(E-Mail Removed)...
> 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" <(E-Mail Removed)> schrieb im Newsbeitrag
> news:ek8Zzsh%(E-Mail Removed)...
> > It likely misses a primary key...
> >
> > Patrice
> >
> > --
> >
> > "Marco Wolff" <(E-Mail Removed)> a écrit dans le message de
> > news:%23dHMjKa%(E-Mail Removed)...
> >>
> >> 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.
> >>
> >>
> >>
> >> *** Sent via Developersdex http://www.developersdex.com ***
> >> Don't just participate in USENET...get rewarded for it!
> >
> >
>
>