Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't insert into VFP table
Message
From
30/12/2006 15:06:41
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
29/12/2006 20:38:21
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01181015
Message ID:
01181082
Views:
8
>I'm trying to insert a record into customer table (foxpro).
>
>I'm using ...ExecuteNonQuery();
>
>My insert statment looks like this:
>sqlCom = "INSERT INTO customer (cust_id, company, contact) VALUES ('SAMAHN', 'SKAHN REST', 'Sam Ahn')"
>
>
>The error I keep getting is:
>"Cannot implicitly convert type 'int' to 'System.Data.OleDb.OleDbDataReader'
>
>What does it not like?
>
>TIA.

Sam,
DataReader is for reading data forward only fast. Here is a sample for insertion:
Re: Using OleDbParameters and FOXPRO MEMO Fields Thread #1026872 Message #1026953
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform