One of the major pitfalls of the new Patterns and Practices Enterprise
Library, compared to the old version of the SQL Helper libraries, is that
the code gets blown up.  Before, using the SQLHelper library, I could write
code as follows, while the new library I must do stuff ...

This is my first c# windows app.
I create a data reader on an Oracle table. Returns 552 rows. I iterate
thru them, goes like light speed.
Next, for each row returned, I need to fetch from another table to get

I want to return OleDbDataReader from a static function,
So I will have DB interface for my Entire project,
Is it possible?
How do I close the connection ??????

I have code like:
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{

I'm trying to insert new rows into a table in an Access database.
Here's my code:
Dim cn As OleDbConnection
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As

We have an application that runs fine for 2-3 days, then suddenly begins
erroring out. This may continue for several hours/days until a job runs on
the database being accessed, then begins running normally again. The time &
number of executions before failure appear to be random ...

I want to load data from two related but different XML files into a two
different DataTables in a single DataSet, then create relations, and finally
filter and select specific data. I can't figure out how to load the two
different sets of data into one DataSet. For example, the ...

We are thinking of using ADO.NET to implement transactions on our
SqlConnections, but would like to know how ADO.NET and SqlServer handle the
situation when the connection gets broken.
We have a client application in one location and a SqlServer DB in another

In our project we fetched data into dataset from the database.
Now we are storing the data in a XML File from the dataset.
The modified DataSet is kept in the XML File And dataset is closed.
Later at the time of  saving we are building the dataset from the XML file

On Sql Server 2000, my program can't seem to find the Stored Procedure:
AddNewResumeTemplate.
The error it shows is:
Could not find stored procedure 'AddNewResumeTemplate '1234',1001,'This is a

Hi all,
I have trouble with the updating of the dataset.  Firstly, my dataset is
bind to a datagrid. After I have added a empty datarow into the dataset, an
empty row appear in my datagrid.  Then I entered values in the columns.  

I'm writing a WinForms app, and trying to decide whether or not to leave the
connection object open permanently, or call .Open() and .Close() on it for
each db action.  My current understanding says that there is no particular
importance in opening and closing the object because ...

  I have a Web service retrieving data from SQL Server
2000 and returning rows which contain a DBNull in a
field.  I have modified the XML Schema according to an
MSDN article, a KB article and a fellow poster.

I want to know what kind of queries can i execute on datatable select method. The one i am interested in is between query
for eg:- this is my sample query
Select max(resultan) from TblseasResult Where SeasId='15.3.13.3302005' And Countno between 4801 and 4806
where Countno is ...

Hi people, i have a question about this:
I need to know how can i obtain the sql queries (Insert, Update, Delete)
that are executed by DataAdapter.Update on a DataSet. I know that i can see
that queries on SQLProfiler but i want to obtain that sentences on my