Im using the following code to sort columns in a data set:
ds.Tables[0].DefaultView.Sort
However, datetime fields pulled from the database are sorted as strings
and thus incorrectly. How do I sort the datetime fields properly?

I I'm running a VB.NET windows applicatrion that is using the enterprise
services transactions.
the app is running on XP (SP2) and connecting to SQL2000 (version 8.00.760
(Build 3790: ) ) on windows 2003 (no SP).

We're getting an occasional occurrence of the following error when two users
try and open the same record in our ASP.NET app:
"There is already an open DataReader associated with this Connection which
must be closed first."

In my C# project..
I have Sql Database  with data of  700 MB... I'm redesign tables and
relations and need to retrieve my data in the new tables..
I'm using SqlAdapter to Get old tables in my dataset then use the

Good evening,
In VB 6.0, Delphi & VC++, the basic database connection technique is to
connect at startup, disconnect at shutdown.  In ASP.NET (regardless of
language), the technique is to connect on demand.

In MS ADO.NET Core Reference by David Sceppa, he mentioned that we need to
call the Merge() method of the original DataSet with a parameter which is the
Changes-Only DataSet after the update to make sure that the original DataSet
understand that we already submitted these records ...

I 'm playing with parent/child relationship columns and I've tried
AGGREGATE functions.
My test is simple:
I've created a table "C" with 2 columns:

Here is the task that I wanna achieve.
I have 2 tables with a parent-child relationship in a dataset.
Let's say the tables are
orders

I'm working on a VB.NET app which uses ADO.NET to interact with a database.
Currently I have a problem with concurrent updates due to the optimistic
locking used by ADO.NET. I wish to be able to modify the data updates so
that they only check the Primary Key columns when updating ...

I get HINTS from the documentation that I should be able to use these with
ADO.NET as if they were stored procedures, but haven't found any clear
guidance so far on actually how to go about doing that. There seem to be
some differences between the way you do it for Access vs. how ...

I have been programming for one year in .NET and using ADO.Net, i've used
several techniques to develop my data access layer in my applications, but
i've found that none of these has been appropiate. My question is there any
place where i can find a model to follow in my data ...

I might be having a dumb moment but .....
I have an excel vba app with a worksheet (Sheet1) containing a QueryTable to
a remote MSAccess database
I wish to use VBA to programatically refresh this data every so often (say 5

   Currently my web service is limited to 256 characters, I would like to
make this longer.  Should I make the field of Memo type and only use POST to
pass the data to the web service?  Are there any concerns I need to be aware
of before allowing lengthy fields?

I need to select some rows from a dbf file and do some processesing for each
one. After processing each row, I need to update some field on it. There is
no column or combination of columns that can be used as row identifier. Can
this be done in ado.net ? How ?

   I have a class library that I am using to connect to an ODBC data
source.  If I consume this class library within a standard windows forms app
the connection succeeds.  If I consume it in an asp.net web service it
fails.  Would this be down to the assembly being run with ...