I am having problems sending a DELETE command using the vfpoledb provider.
Funny thing is, when I first implemented this it worked fine now I get the
following exception from the provider about 80% of the time:
"One or more errors occurred during processing of command"

I a m trying to loop through the columns in my DataTable and do
different things based on the data type of each column.
For testing purposes I tried the following code...
   Dim MyColumn As DataColumn

We are persisting data in session. Is it better to store data objects as xml
strings or to serialize the objects? We are not supporting hundreds of
concurrent users but we are concerned about performance. TIA for your input.

Here is my problem statement/ background
Background: My program reads an excel file and populates three datatables
depending on the value in one of the columns. Now when i create a
datarelation and try to combine the tables, I loose values that are unique

I am coming from MS SQL Server background. And too used to SPs. Here is
my question-
I want to insert data into a table and one of the columns is a copy of
the primary key which is an auto increment field. How can I do this

Hi. The project I am working on has its own Data namespace (e.g. MyApp.Data
). Within this namespace there are System and DataSet namespaces/folders
(e.g. MyApp.Data.System and MyApp.Data.DataSets ).
Because of this the autogenerated dataset classes within the DataSets folder

And why the frick is it sooo damn hard to find information on this
crap, anyway?!?
Help!
-Skipward

I have a dataset with many tables in it.  Two of them are Persons and
Objects.  An object may or may not belong to a person.  I'm reading in an XML
document for my data source and creating a parent/child relationship between
Persons(parent) and Objects(child).  When the object ...

I am stumped. I have a strongly-typed dataset with many related tables. I
delete a row using Rows.Find to get the row and then call Row.Delete.
However, even though it is no longer visible in the DataSet, calls to
GetChanges and DefaultView after RowStateFilter = DataViewRowState ...

Hello NG,
i have here a functon wich I use to restore a certain state of
a DataTable. Its working but you might find some points where i could get better performance.
With MS SQL Server this funktion is fast enough for me (it takes for a DataTable with 10000 Rows about 1-2

but I am trying to generate a DBConcurrenyException to at least put up a
warning message to the user if a database table has been changed by another
user before being updated by this user.  
data table-for each new record inserted the web app increments column 1.

What is intrinsic objects of ADO.net?
Thx

what is the equivalent of the below ADO code in ADO.NET
Set objRs = objConn.OpenSchema(adSchemaTables)
thanks

I'm using SQL Server and I have a column for storing photos of the database
type "image". I want it to be optionally NULL. I have a stored procedure
that I use to populate the table. When I run the stored procedure from the
query analyzer tool, I have no problems. I can pass in a ...

I'm learning ADO.NET and I have strange problem. I have Oracle 8.17 localy
installed and I created a simple table called mytable. In VS.NET, C# 2002 I
added OleDbDataAdapter component and used "Configure DataAdapter" to create
connection and configure it. SQL statement is just a ...