Indeed, a count of a query with a group by function gives more records than
there are and so for-next  structures don't function.
How is this to be mended.
Anyone? Everyone in fact.

I am really stuck and hope someone can come to my rescue.  I need to be able to call
dataReader.GetBytes for a column which is defined as a varchar2.
When I try to do this I get an InvalidCast Exception.  Why do I need to do this?
The drivers for Oracle or somewhere in between is ...

Is there an equivalent?  I have a sequence set up to create me a unique ID,
but I need to return that too!
Thanks,
Scott

Is there anyone who would like to have a look at my simple to give me some
advice for improvements?I'll send it in zip-file.

where i can get the fully functional version of .Net framework that can run
crystal reports too?
Best wishes

I have on  clsGlobal.cs File in which i have created many functions of
Fetching, Inserting Data In Database.. Using Ado.net AsP.net C#.net
Those Functions returns String, Dataset etc.
But NO WHERE I AM USING DATAREADER IN WHOLE PROJECT.

I've seen posts on this, but never a confirmation that anyone's suggestions
actually worked...
I have a sql stored proc that returns multiple result sets.  I used the VS
dataset designer, and just drug the stored proc onto the designer to build

I'm using System.Data.OracleClient with VisualStudio.NET 2003 and trying to
connect to Oracle 9.2 database. Oracle client software for 9.2 has been
installed and I can perfectly make a connection in a Windows Forms
application. But on the same machine, I cannot make a connection in ...

Given the following situation which is better, should the data be read using
a datareader then put into a grid for inline editing, etc. Or should it be
placed into a Datatable then datagrid for the same activity?
web app., maybe 50 users at once, record size maybe 100-250.

I had a question in comparing ADO to ADO .net, specifically on the
performance side.  Here is some background:
Our application is a very data intensive one, we have a middle tier,
which is our database interface client, which talks to many SQL Server

I need to write the contents of a dataset to a comma delimited csv file that
includes the field names?  Does anyone have a sample of how to do this?
Thanks

Hi,
Got a small app based around a access database. In
ADO.net i simply called update method to uptade my
database with dataset contents. i.e.

Why do I say:
   SqlDataReader dr;
instead of
   SqlDataReader dr = new SqlDataReader();

I'm using ADO .NET to connect to a Microsoft Access database, and
everything so far has been working in my program except one small
problem. I am constructing a query string to search for certain results
from a table, and it does not seem to return the correct results.

I want to grant updated privileges to a column only, but I can't get the
syntax right.
grant update  columnname on  tablename to username
gives me syntax error.