I would like to write a program to convert Access tables to SQL 2000 tables.
I could certainly write a program which collects each field in the access
table and creates a similar field in SQL 2000 and then populates the file,
however I am assuming that XML may offer a solution which ...

I am currently designing a program that uses the ado.net.
I have a question..
Which is better? To have your data constraints implemented on the dataset or constraints on the database? Or both
Thanks a million

I'm wondering how to do something like this.
In database is for example 'QualityClasses'-table containing columns
(fields) 'ID' which is primary key (Data Type=int), and 'QualityClass' (Data
Type=varchar).

Thanks

I have written my own DataAdapter for my DBase IV file(s).  The
Insert, Update and Delete calls all report success when I call
Update(...) on the DataAdapter.  Unfortunately, when I recall the
data, only the Inserts and Deletes actually worked.  For some reason,

I'm writing a class that crawls through a removable media retrieving file
info (who didn't make one yet?) and storing in an Access mdb.
OleDbCommand fails when the file name contains quotes as in
My friend's pictures.zip

Looks like I've got a lot of reading to do :
As I understand the concept of Singleton objects, they can only be instantiated once.  Then, all other calls to that object rely on that previously created instance.  If you have 300 hundred users, and each of them are doing multiple ...

In preparation for an app that will be a simple ASP.NET page with about 40
text boxes I need sample to do the following:
1.  Select the current data (done)
2.  Bind to the textboxes (done)

I'm trying to get the ID of a newly created record into a variable, so I can
display it in a Label or something after being created. I know you can use
@@identity in the sql statement, but I just can't seem to get it to go.
Any help appreciated,

I'm getting the following error - not always, only randomly - when I run a
certain routine (the routine is a simple executenonquery and it appears to
complete despite the message) against sql server 2000:
"timout expired.  The timeout period elapsed prior to completion of the

Hi Gurus,
This has been doing my head in so I've come the you guys.
I have 2 DataGrids using a DataViewManager to source their data. They
are linked via a DataRelation which basically creates a Parent-Child

I'm currently investigating what new cool features ASP.NET 2.0 will bring.
When I use a GridView and a SQLDatasource like this:
<asp:gridview id="GridView" runat="server" font-size="8pt" backcolor="White"
allowpaging="True"

I am having a problem with passing a comma delimited string as a parameter
to be used in the IN() clause for a record selection. What I want to do is
select all customer who have a surname that matches one in a specified list,
which I pass in as a parameter to the query. I am ...

Can anyone please answer the following question?
I'm trying to get a list of tables, which has to work for different
databases.
A user chooses a database, and then this list is showed. This works.

The SQL Statements the CommandBuilder creates never work. (Wrong INSERT INTO
...)
To test this I created a new Access DB and a new application.
I used the wizzard in the IDE and here is the result: