In the code below, any attempt to read data results in the exception
"Invalid attempt to read when no data is present."  Examining the
DataReader, the _dataReady is false and HasRows is true.  This stored
procedure returns around 1000 records.  Any idea why I'm getting this

When I call a dataAdapter's Fill method to load a multi-
table dataset from SQL Server, I can use a sql string
something like "SELECT * FROM table1;SELECT * FROM table2"
as the command text and it will give me a dataset with two

The following code snippet fails if the column contains a DBNull value.
private SqlParameter[] BuildSecurityParamaterArray(
SecurityDS.lac_SecurityRow sec )
{

Hello, everyone:
I am writing an ado.net componet in c# to fetch data from MS Acess database.
I got a problem is some table has column with space, such as "company name",
Could anyone tell me how to select this kind of column?

Is it a valid DataSet which contains multiple tables with no
relationsips between them?
Should I anticipte any problems working with such a dataset.
Situation:

   I am trying to perform date searching in a database via SQL commands.  I
want to be able to retrieve items before, equal, and after a sepecific date.
The only way I can think of doing the before or after comparrisons are via
VB.NET's "ORELSE" keyword, is there an SQL ...

Hello,
I'd like to alter the font, including the background and the
foreground color of individual cells for a realtime app'.
this.dataGridView1.ColumnCount = 5;

  Ive been successful in trying to read a blob XML (XML
is stored as blob in database) into a Dataset. However the
process seems to be very slow. Ive used the following
method.

I have a typical Products->OrderDetails->Orders type many-to-many
relationship expressed through a junction/x-ref table in a DataSet.
How do I get a DataView of relevant Orders starting from a given Product
row, using existing indexes and sorting results by an arbitrary column

VB.net... working with a MS Access db file.
For no good reason, I'm suddenly getting the following message on my
application:
--->  The dependency 'Interop.ADODB' could not be found.

I have created a Dataview and have sorted it on the Date and ShiftNumber
columns
this works great, but when I want to use the Find Method it gives me the
following error:

I have an application which communicates alot with a SQL-Server.
It has grids for displaying data and edit-forms for editing data.
I have an AppException handler so I will receive all unhandled
exceptions and ignore them if they aren't important.

If any one has idea how to search Datatabke/dataview like "LIKE in sql" by
using Dataview.Find method or any other way, can you please let me know
Thanks

I am trying to populate grid using OracleDataReader and it seems
Datareader.Read() is taking alot more time in reading the resultset(around 12
seconds in reading 50 records).
the same sql statement  in SQL plus is taking less than 2 seconds.

We are new to ADO.NET, and any help would be appreciated.
The scenario is as follows: we have a large number of objects
(thousands) to write to a database. Each object has a method that
returns the SQL query which will update a relevant table in the