I have a DataTable in a DataSet. The ColumnNames of two of the
DataColumns are First_Name and Last_Name. I have added another
DataColumn and set the Expression property to:
First_Name + ' ' + Last_Name

   I have two datasets that have the same schema. They have different data.
Both are in an unchanged state which means when I do a ds1.HasChanges or
ds2.HasChanges I get false.
   Now how do I find the differences between the two?

If I convert my dataset (8000 rows) to an XML file is it possible to pass sql query against this file at different intervals or as long as the file exists
Thanks

Hopefully I've got the right discussion group
I'm building using a web app using VS.NET 2002 / SQL 2000
The following should process the details from an online form to a SQL db but when the Submit is pressed, the form looks like it actions, but NOTHING is added to the DB! Am I ...

I use Remoting in my WinForms applications and my forms
usually call some type of GetInitData method of the
Business component that returns a DataSet.  The
GetInitData method usually calls classes from my Data

I have a datatable with some columns of int data type. I have been
using the datatable.compute() method to calculate the average of a
particular columns for all rows. But the result given is of type int
and not float. In essence it is reportingthe avg of 2 and 3 as 2 and

I am using Managed Data Provider from Microsoft. There is a sample codes in the help document:
Public Sub CreateOracleConnection()
   Dim myConnString As String = _
      "Data Source=Oracle8i;Integrated Security=yes"

Is it possible to do an ADO.NET transaction using just the OleDb space
and not touch the managed SqlClient at all?
I am trying to build a common data component that must work with
Oracle and MsSql and 3 other databases, all support XA-style

   In my asp.net (vb) application I'm displaying data from a table in a
dataset in a listbox. The data displays as I want using the .DataTextField
property, but when the user makes a selection I need to return more than one
value in a row. This is because the data has a compound ...

I currently have a Dataset with a single Datatable, which is filled
using a DataAdapter. I would like to run a SQL query on the Datatable
and create a new Datatable in the same Dataset with the results from
the SQL query.

I've written some code that uses the import method of a DataRow object and when I submit it for updating the changes were not being populated to the Sql Server Database.  I noticed in debug mode that the RowState property for each row imported is "unchanged".  I have a hunch that ...

I have a StoredProcedure that returns a ref cursor and a numeric value.
I want to populate a datatable with the returning cursor, use the numeric
value elsewhere.
What is the method for this ?

This is probably an easy question, but I can't find the answer
anywhere.  I have two datatables in my Main_Dataset (untyped).  One
table contains all of the information from the table in my database.
The other is supposed to contain only 5 columns of information.

When useing a Crystal Report (CR) bound to a dataset.xsd, the paramenter do not show up in the CR Field Exploere.
The parameters are defined in the stored proc that I used to create my dataset. file.
Yes I can access them via my VB.Net code, but I am unable to access them and their ...

The problem is that when the RecordSet is in changing ,after oda.fill,the All rows int DataSet.tables[0] will lose changing state
for example,there a ADOr.xml file
<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882
    xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882