I am not too sure if I understand the connection pooling or not. But I
am implementing an application where in one page I open connections a
few times each time I close connection properly. My question is thanks
to the connection pooling the first opened connection will stay in the

We are experiencing a weird problem where a call to a stored proc using
native SqlClient connection class in a VB.Net app fails on one machine when
processing a large set of data (23,000 rows) BUT will always work on another
PC. We checked patching and both are (now) running SQL ...

I have to build dozens of simple data-entry forms in just a couple of days,
and while I'm looking for a 3rd party tool that will help me do this, I
tried the Data Form Wizard in Visual Studio, which builds a persistent
dataset object based on a chosen table or view, and produces ...

Hi, I have a little application coded with .net 1.1, my problem is that this
application worked fine in W2000. But the client change to XP, and from that
get this error.
This problem show when try to read from a table of Access XP.

can any one tell me where the "Object Reference Not Set to an Instance of An Object" error is coming from in the code below? the procedure before logs on w/ no problem. i cant figure out which ref to which obj is getting lost.
thanks for any help.
ps. i ripped this code right out ...

I can't find any answers, I have no idea why this is happening.
I have a dataset. In this dataset there are three tables
RO
ROParts, ROLabor

In my VB.NET 2003 Winforms app I fill a typed dataset with 1 record from SQL
Server. I'm not using databinding on my form, so I want to programatically
change values in the dataset with values from textboxes and listboxes, then
update the SQL Server table with the changed dataset ...

I have a typed dataset with three tables, one master and to child.  This is
a contact management app, so I pull all of an organization contacts and
associated details into the set. (Anywhere from 1 to 100 contacts and their
associated detail).  My form is bound to the dataset using ...

First of all, thanks for the help on my previous VB.NET/MS Access questions.
This time I need do the following
1. Connect to a table
2. step through each of its records

All,
Using C# with ADO.NET I am trying to save a date time to an Access database.
After the saving occurs I open Access database and only see the date not the
time.

I'm splitting a csv file into records and then into string fields.  Then I
load the string fields into a new DataRow using ItemArray property.  I set
the DefaultValue of the fields to the approprate type. This part is very
fast but then I have to load the columns based on the ...

I have a grid that is bound to a typed dataset.
Three fields make up the key in the parent table and those same three fields
are also in the child tables with a 1 to many relationship.
When I bind this dataset to a grid it displays it hierchalily (which is what

I could use some help regarding transactions.
I am using the System.Data.SqlClient namespace to work with a SQL
Server 2000 database. In the database I have 2 tables that are related
to one another. One table holds a facility (a location), and the other

Can anyone help me out from the above by giving a code snippnet including the
import namespace directives.
Regards/CS

I written myself some small generic class to export any dataset to an
excel spreadsheet:
public static void Export(DataSet data, String excelFileName)
{