I've tried with:
dsAESWS.Tables["aes"].Columns.Add("F35_GROSSWEIGHT_TOTAL",
typeof(decimal),"Sum(Child(dsAES_aes-aes_packages).F35_GROSSWEIGHT)");
dsAESWS.Tables["aes"].Columns.Add("F35_GROSSWEIGHT_TOTAL",

Why does the insert command not work in a transaction?  I am using OleDb
with MS Access and ADO.Net and VS 2003.net
I create the connection and dataadapter initially in a function and return
them so I can reuse them

I have a Windows Forms Application with a DataGridView which is bound
to a typed DataSet. For reasons specific to the application, I add a
record to the database table when a button is clicked on the form. This
button creates a record with default values so the user only has to

Does anyone know if it is possible with .NET to load an XSD file and
use that as a database schema template to generate a new database?  I
had hoped I could load the XSD file into a System.Data.Dataset object,
and then pass that to something like a

For various reasons I am accessing data from an access database with
multiple tables.  I am unable to upgrade to SQL Server (even the
express edition), so I have to do this in access.
At the moment, my sql statement is as follows:

I have a C# Desktop application that uses ODP.NET as the data provider.  I
want to find out if there is a way to include ODP.NET dlls along with the
application MSI.  Just including the Oracle.DataAccess.dll within the msi
does not work.  Maybe I need to include ODP.NET within a ...

Well, I've taken poetic license with "newby" having been programming
for more than a couple dozen years, but I have recently started
studying .NET and ADO.NET, leveraging my experience with other
frameworks such as Borland's VCL, and MS' MFC, and technologies such as

I found that when I fill over 10,000 records to a dataset, there will be an
error "Internal Connection error". Please help.

I am trying to be a thorough coder and create an app in layers.  I can
do it using the sqldatasource but I really want to try creating the app
with tiers....thus....
If I use VS2005 to create a typed data set, I see that I can allow VS

I am getting a NoNullAllowedException when I try to add a datatable to a
dataset by using dataset.tables.add(datatableOld.copy()).  I checked the
AllowDBNull property on the column of datatableOld that was throwing the
exception and it is set to "true".  I am not sure why I am ...

I am really confused about TableAdapters, Datasets in general.  I have
added them to my Windows Form simply by dragging fields onto my form.
Now, when the user presses the Cancel button, and I want to determine
that something has changed, ie, If Me.MYDataSet.HasChanges = False,

What objects and services do I use to visualize the collection of tables and
the table's collections of columns in a SSCE database file.
Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to allow
me to see the contents very quickly. The Data Source Display inside ...

I have the following code to open a database. Since I don't have the db as
specified in the connectionString, the connection.Open() will throw an
SqlException. My question is why it opens the "SqlException occured" dialog
before it goes to the catch block? Is there a setting to ...

  I am implementing Business object, but while implementing this I
want to have DataTable or DataSet as part of Business Object. For
example, I want to bind controls directly to these Business Objects. So
please suggest me how can I achieve this??

I want to send fax using vb.net coding through rightfax.
I have referred rfcomapilib.dll.
An error has been occured when i create a object of the faxserver during
running.