does anybody knows of a free sql database (tables) with USA cities and
states info available for download?
Thanks,
Alejandro.

Problem:
I have two databases db1, db2
db1 contains a table with a keyfield ID  (ms Access -- oleDbconnection1)
db2 contains a table with a keyfield ID  (SQL server -- SqlConnection1)

I'm getting the following error:
"This row already belongs to another table. "
For this code:
while(myEnumerator.MoveNext())

Does anyone have an example to store the connection string to a file, which
can be edited so that the application can run on clients environement.
hardcoding the connection string doesn't seem to be a good idea.
Thanks

I know there is a lot of talk on here about merging, but I just can't seem to
get the DataSet.Merge to work with XML data. My scenario is that I have a
DataSet populated with complex XML. Every so often on a timed interval I get
sent to me a new set of XML (could have changes, ...

I have a big typed DataSet (dataset.GetXml().Length approx 5,000,000).
I want to expose this dataset as a webservice, but it is too big.
Then I want to filter this dataset to reduce it and expose it as webservice,
filter criteria given by WS consumer.

When using a typed dataset is it possible to do the following:
1 - force date values to get saved as just the date part...
       "2005-01-28"
   not

I am trying to create a program which will provide some basic Sales Analysis
data to my users, without having to build cubes on my server. My data exists
in four related tables. Customer Groups, Sales Channel, Invoices and Cost
Detail.

i am trying to insert data into sql server db using ado.net (vb.net) thru an
insert statement. I have a uniqueidentifier field in the table and asp.net
converts it to guid field and when i put guid.toString value in insert
statement  

I want to connect sql database via ado.net but error is encounter as shown
as below:
Compilation Error
=================

I'm bulding SQL Commands with
System.Threading.Thread.CurrentThread.CurrentCulture = cu
String.Format(MSSQLComand,  Startdate.ToShortDateString,
EndDate.ToShortDateString)

   Whenever adding or modify row to the datatable, RowChanged event getting
fired. But it is not getting fired when deleting the row from the table.
  Is there any event fires when deletion of row happens ?
  Regards

Is is better to:
(1) Have a single connection object in a database class which is
instantiated when first used at start-up and used by other classes (opened
and closed as necessary - NOT kept open).

I don't understand why the question below has not been answered here.  I
assume I am in the right newgroup.  To me it seems a reasonable question.
What gives?
If reviewing how to get the DataRowVersion data from a row in a dataset I

Can anyone direct me to where I can find sample code on how to connect to an
Exchange Server with .NET?
The Exchange OLEDB Provider doesn't seem to work with ADO .NET?
/kk