Say I wanted to do an aggregate sum (using the Northwind examples in MSDN
help) where relationships between 2 datatables exist, I would use:
SUM(Child.Price)
However, if I have a "IsDeleted" column in the child table, how would I

I think i am in front of a simple problem but as I am a beginner I cannot
solve it.
I am using a wizard generated SqlDataAdapter. It generates for me all the
Sqlcommand and also a stronged typed dataset. The SqlDataAdapter is basic

I have a list of 2 tables, using asp.net/ado.net I want to find out the
foreign key relationships based on the physical structure of the
database. Any idea how can that be done?
Thanks,

I am attempting to connect to some Oracle 9i databases from ADO.NET. The code
I am using is straightforward and taken from MSDN (partly reproduced below).
I am using the DOTNET Oracle driver.
The problem is that while it initially works, it does not work after the

What makes a PrimaryKey in a DataTable sometimes removable and other
times throw an Exception when the attempt is made?
Thanks.

Informix Issue:
I know this is rare, but if there are any developers that develop on an
Informix database using ADO.NET, I'd like to know if you are having a
performance issue returning in excess of 1000 rows using the Informix .NET

Can anyone give a quick example on how to store a Table returned from an SQL
Server User-Defined Function into a DataReader object?

I have the following code that binds a datatable to my datasource. Problem
is, the table has about 25 columns and I only really want to see 5 of those
columns. I know I can do it by changing my initial SQL query but that means
if I want to use other data later on I have to make ...

We are having a memory leak issue and looking at possible causes. Do
datasets and datatables need to be explicitly disposed? My
understanding is that this is only required with connections and
datareaders.  In fact doing so on a dataset could be a problem if it is

Hello, I have a simple ADO.NET question for someone who knows their
stuff. This has been bugging me.
Here's the basic question: What is going on behind the scenes when I
create a detached datarow and then call datarow.table.add? What's being

I'm using SqlDataAdapter to insert data from one table into another with
SqlCommand after I start a transaction.
If I have convertion error for the insertion of the data, The transaction is
no longer valid, I'ts rolled back.

I have a desktop application, which I use to connect to an SQL Server
database as follows :
m_ConnectionString = "Data Source=ServerName; Initial
Catalog=FlattedProperty;"

Hi everybody I have a problem I've struggeld with for some time. I have
a DataTable with one column (say column 3) generated by an expression
like : Col1 * Col2 and the rusult has many decimal places. The column
data is of Decimal Type. Now is it possible to limit the decimal places

  I and using a dataset with multiple tables, all related, and I'm using
browser like navigation (via the plus sign on the left side of each row in
the datagrid). Each DataTable in the DataSet is 1:1 with a view in a
database. The dataset is the DataSource for a DataGrid (pretty ...

Can someone please provide me with a working code sample (PL/SQL, VB.NET or
C#) on how to retrieve a out ref cursor from an Oracle 8 database to an
ASP.NET DataSet.
Thank you in advance.