In the code below, I am trying to change the select statment to be
"distinct" , ( i have also tried "top 1"), but when the code runs I always
get the original query "Select city from doctors".
Here is a code extract

Is it possible to execute an Access report via ADO w/o having to resort
to using the Access automation server with COM Interop?

What is the best practice when importing Excel data to an access database?
Totto

I want to connect to Oracle 8.1.7 server through my application. I would
like to know which .NET data provider will be the best option? Microsoft
Oracle Provider or a ODP.NET provided by Oracle.
Here server is hosting databases for many other applications and

I have been reading somewhat about this error, but I am confused as to why
mine is happening.
I use a single, static connection from the instantiation of the form in my
project.  Against this, I run DataReaders and then close them immediately.

I use the OleDb objects to connect to an excel file and retrieve data from a
specified worsheet.
What SELECT statement should I use (if there is an existing one) to retrieve
the names of the worksheets in the file?

Does anyone know why Intellisense frequently stops working for strongly
typed datasets when the dataset is in a referenced assembly?  Within the
assembly where I have the dataset, it works fine, but outside of that
assembly I can rarely get Intellisense to recognize anything ...

I have some data that is disassociated, I am trying to put an ad-hoc
relationship into it so that I can get it hierarchical.
What I need to do is create a relationship on two fields in a table. Is it
possible to do this?

i have some wired behaviour using c#, ado and sql server.
There are two tables on sql server: Order and Orderdetails.
(Order_ID is primary key on Table Order and foreign Key on
Orderdetails.)

SQL Server 2005 enables the creation of procedures, functions, etc. using
managed code. Since you can use managed code, sooner or later you'll want to
access some data in the same or a different server, and for that you'll most
likely use ADO.NET.

Hi, if this is not the appropraite list, forigve me and point to the correct
one.
I have a custom .NET Provider implementation that follows all guidelines.
I can connect tot he database, fill dataset, use it in all kind of query

Ok I want to filter a dataset into a dataview and be able to reference back
to the dataset from the filtered dataview.
Example:
100 record dataset

I am returning multiple datatables from a stored procedure into a dataset.
It keeps naming the datatables as "Table","Table1","Table2" etc. Is there a
way i can change the sproc so that my datatables get created with a name ?
The multiple select statements have multiple joins too ...

I am trying to generate Excel sheet using
Provider=Microsoft.Jet.OLEDB.4.0;
I am always getting the error while inserting data into any cell other
than A.

I am using ADO.Net in VB.net application. .Net Framework 1.1.
In a stored procedure I have multiple output parameters and multiple result
sets. How to code for this in ADO.Net?
I have used MyCommandObject.ExecuteNonQuery() when there were only output