I have a datatable that contains about 25 rows of data.  Whenever I make
changes to any row of data I submit them to the database.  However, in my
table there is a timestamp column.  What I am trying to do is retrieve the
new  timestamp values of all rows that were updated (I'm ...

Hi, let's say that the result of a query that has some joins, brings back
some columns that have the same name. .Net starts numbering them.  So they
became "someCol", "someCol1", "someCol2", etc, even though in reality, they
were all called "someCol".

I am rewriting a VB6 application in VB .Net.  The database (which was
converted from Access 97 into Access 2000) has two nearly identical queries.
One, called GetNewOrderNumber, is:
SELECT IIF ((SELECT COUNT(*) FROM Orders), Max(Order_number) + 1, 1) AS

how to setup the port to use ?
in the list of parameters I can't see the port, or is it the 'Address' with
a format: 'server:port' ?

Wchich is the best way to modify data in a DataSet (or DataView, dataTable).
I want to find specific recorsds and modify one column based on valueu from
other columns.

I have been reading about ADO.NET's connection pooling and have a
question.
Our situation:
In our system we have a LOT of different user databases.  This is a

Hello everybody
Does anyone know how to update a table having 2 primary keys?(with MS Access). I am using datasets and update commands.
Thanks.
---

Can someone help me understand why the following code won't work?  I'm
connected to an Access database with a connection object, but I'm unable to
populate the dropdown list box on the form.
Also, I can't seem to print diagnostics anywhere using "Response.Write" or

This might seem naive, but been spending quite a bit of time on this;
was wondering if anyone could help me out here.
My problem is as follows:- I have an (MS Data Access Applications
Blocks-generated) untyped dataset that has data grabbed from the

This is the case I have several pages that together allow the user to drill
down, eg Jobs,Sub Job, Task
On the Job, the job details are displayed in a datagrid which the user can
sort,page through, filter and select an active row.(each other page has the

I'm looking at how best to synchronize a semi-connected client d/b with a central server d/b and thinking about serialized DataSets over Web Services. All well and good
On the client side I can do something like keeping a DataSet in memory and calling GetChanges() on it to send ...

I really messed this up now. ....it is not picking up any rows though it is
suppose to have.
       Do
           i = i + 1

I am trying to create a web page (VB aspx) that users can http browse
to and get a tally of their appointments and their catagories (these
user track their work load by booking appt ments and classifying them
by appointment catagory)

Could any one tell me what is the latest version of System.Data.OracleClient? Currently I'm using version 1.0.1012.0 in my project which is giving problem of not closing connection eventough I'm issuing connection Close() statement.I am trying to connect Oracle 8i from ASP.NET ...

I just started having a problem with Oracle 9.2.0.4. When unit testing my dlls I have no problems, but when I call the dll's from a web app I get this error
System.NullReferenceException: Object reference not set to an instance of an object.
After stepping through the code is ...