I would like to build a monitor application that monitors the connection pooling. I know that it is possible to use PerfMon for SQL Server, but I would like to build my own to deal with other providers.
Does anyone have any link to articles or any other information that I could ...

I'm using VB ADO.NET with Northwind database Employees table. I create a
WinForm with
a ComboBox (cboEmployee) to let user to select or enter full name and store
it in strNames string array.

I have a DataTable setup and want to be able to change the columns at
runtime so I limit the number of rows returned.
I know you can have have multiple queries within a DataTable but they return
empty columns which I don't want (or is there a way to stop empty rows being

I'm new to ADO.NET 2.0 so I have some questions you may be able to help me
with.
1. I decided to take advantage of Strong Typed datasets. Everything worked
but I did not really like the way I had to deal with the TableAdapters. So,

Background - VB.NET v1.1 SP-1.  Query Oracle database using Microsoft .NET
provider for Oracle (System.Data.OracleClient).  Exception is thrown using
both get data methods: 1.) OracleCommand.ExecuteReader() 2.)
OracleDataAdapter.Fill()

I'm reading CSV-file using OleDB provider with SQL-select command and
it's working fine. Anyway CSV-file contains "field" containing date
values like 20060825, and I'd like to convert it into datetime format
when reading it into DataTable like #8/25/2006#. How to do this?

When I try to connect Oracle 10g db from windows 2003 server I get
error "System.Data.OracleClient requires Oracle client software version
8.1.7 or greater"
On the Windows 2003 Server

I have created a DataSet out of an SQL Server DB. In the server, there are
several 1:1 relations, in the graphical representation of the DataSet in
Visual Studio, it seems as if there were just 1:n relations. Why? Is it a bug
in VS 2005 or is it impossible for an autogenerated ...

We are moving our software to the web using ASP.NET 2.0 and are researching
ways to enable our software to connect to multiple databases, specifically
Oracle, SQL Server, and ASA. We have used ODBC in a client-server environment
in the past, but have now stumbled upon Provider ...

I am receiving a System.NullReferenceException error when the ImportRow is
executed.  However, as you can see there are rows in the table and I can see
the data in Rows(0) in the
dsetTempPlaceInfoFromPt.Tables("Places").Item.ItemArray of QuickWatch.  Thus

I program using ADO.NET and plan to generate a crystal report. Can DataSet or
DataTable be the "DataSource" for a crystal report (just like DataGridView)
which simplify display of rows and columns?
What make up the data source for crystal report?

If I create a simple collection with say 20 columns and 5000 row and a
DataTable with the same and serialize both, the DataTable file is at least 2
times the size as the simple collection. What is all the overhead with the
DataTable?

I have data values that are inherently of type Double.  Current we are using
Oracle Column Datatype NUMBER.  When I create a TableAdapter in VS2005, the
database table column information is read from Oracle and a new Table is
created.  However, the detected datatypes are always ...

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;

I have a SQL INSERT statement.  I'm pretty well-versed in SQL but NOT in
VB.NET / ASP.NET.  I would like to know what VB code is for inserting a new
row into a database.  I have a SQL Table established already.  I would like
to know the code required to insert a new row to that ...