I totally messed up when asking the question.... Here is my problem
statement/ background
Background: My program reads an excel file and populates three datatables
depending on the value in one of the columns. Now when i create a

Below is the code I have in the Page_Load event of my web application/page.
However, the records I select are not being deleted for some reason. It does
go through the code(look at: 'find the specified row and delete it' section)
and the msg label does say it was deleted. When I ...

I am working on a project that will support several different database types
(Access, SQL Server, MySQL and Oracle) and was hoping that everyone could
help shed some light on the different options that are available for this.
What I am looking for are suggestions on a "generic" ...

I am started using new version of Data Access Block that is included in
Enterprise Library. I noticed that it uses instrumentation a lot. I don't
need instrumentation and it slows down my application - at list at start up.
Also I get errors because of it.

I have a table with 78 fields. I use the Description ( typed in with
Enterprise Manager ) field to group my fields for displaying on a tabbed
dialog.
To get SchemaData I do.

string strDSN = lstDSN.SelectedItem.Value.ToString();
OleDbConnection Conn = new OleDbConnection(strDSN);
Conn.Open();
Why the above code fails at line second. I want to open the conection using

Can anyone tell me if its possible to pass in a variable number of parameters
into a Stored Procedure.
Thanks
tce

We developed an application library which uses Access 2000 database to
maintain look up data. Right now, whenever the library need data look up, it
opened the database and then closed it after it is done. We created a simple
test application utilizing the library. We observe a call ...

I have a crystal report that I want to print using a single record. I want to report on any changes that have taken place through the bound controls. I am using the following code to get the current row that is being displayed (MOD_NO is the primary key field), and merging it ...

In the following code, I am trying to find a record in my Operators
table based on the field ID. I have a record with ID = John (cap J).
The code below returns this record even thoug I did the select on john
with small j. What am I doing wrong?

I wonder how do I store these records into SQL Server table of the following
SQL Statement?
SQL Statement
==========

if I have an asp.net application where the requirement is that it should
handle a peak of 5000 simultaneous user connections, how should I configure
the connection pool? Should I create the connection pool to have a size of
5000 out of the gate? Is there a way to tune the ...

I'm trying to make the DataGrid Fill the whole window in width of a WebForm.
Any help
greatly appreciated.
Dee

I have a Windows Forms app deployed on Terminal Server.  When the app
starts, it loads up several datatables that then serve as the datasource for
comboboxes throughout the app.  One of these datatables has about 5000 ROWS,
at 2 columns each.  I would like to avoid having each ...

Code:
Dim oXL As Excel.Application
       Dim oWB As Excel.Workbook
       oWB = oXL.Workbooks.Open("C:\data.xls") '---> Exception thrown here