My application is using the SQLDataReader to retreive and itereate thru rows
of data from SQL Server, then for each row of that SQLDataReader, selects
related rows from another table via yet another SQLDataReader. When I finish
with a row, I do a SQLDataReader.Close and set it to ...

I have a class library to insert a new record into a dbf file. I always get
exception "Operation must use an updateable query" when the function is
called by a Asp.Net function. However, the insersion works well when I call
the function using NUnit. The following is the writing ...

I have a DataGrid bound to a DataTable. I need to select a record in the
DataGrid that correspond to a DataRow with specified field "ID" value, but
DataGrid should be sorted by "Name" value.
As far as I see, there are no way to do this in performance sensitive way.

I have two DataSets and need to get DataRows from one DataTable into
another.  Is this the fastest way?  I am after pure speed no matter
what the "cost", in this case.
  DataRow[] dataRows = oldSet.Tables["OldTable"].Select();

I am having a major issue with strongly typed datasets.  I have been
using the Server Explorer in VS.net 2003 to add tables from the
database into a DataSet.  I cannot access the rows or columns of some
of the DataTables.  What can I do to fix this, or why can I not do

Hi,
I have a password protected access database. There's no username /
password, only the database password. When I'm creating the connection
to database the dialogbox ask's username (blanc) password (blanc) and

I am trying to call several Oracle Stored Procedure using the "MS OLE DB for
Oracle" driver, and have gotten the same error regardless of the SP I call.
The error is:[pre]
ORA-06550: line 1, column 7:

I am getting issues that Oracle collecting opened sessions (connections)
from my webservice using regular System.Data.OleDb.OleDbConnection object.
I am guessing that this is connection pooling issue. Is there is any way to
disable connection pooling for one particular .net ...

I'm updating a table but trying to do it afresh every time i.e. erase any
records in it and start from the start. The only problem is that the primary
key doesn't re-set to its initial value i.e. it merely starts off where its
last maximum value was.

Hi, there
I have created an stored procedure using the DDL below for my MS Access
Database and no error occurs. Also it can create an stored procedure if I
changed the parameter from "[zSampleName]" to ""@zSampleName".

I've got a query where if I run it from query analyzer it takes about 1
second, but if I do it from an aspnet page, it takes about 54 seconds.  Can
anyone suggest reasons that this might be?

I have created 3 sqldataadapter. each adapter.selectcommand has a
parameter. I have added a textbox to supply a value for each
parameter. My problem is when I press enter the second time to fire up
the keypress event from the textbox I recieved this error in datagrid

I have no problem setting the selectcommand in sqldataadapter to fetch
record from sqlserver w/ where clause in parent table. however, my
problem is on how can i fetch the child table which is related from
the parent table.

We are storing Icons (.ico) files in our SQL Server Application as type
Image. We have a web service call that returns these through a DataSet and we
write the DataSet to disk using the WriteXML Method on the DataSet object. We
persist them locally for performance issues. When ...

Im my ASP.net project I do a lot of connection to the SQL Server
Database. I use a global variabe for my connection declare in a module
(VB.Net code behind)
All is ok but when I start a form from the default page it takes 30