I've seen an Introduction on ADO.NET with its Datasets on .NET TV and Iam
now wondering how it is realized/used in real world applications.
I don't believe that one would create a dataset and add relations to it and
so on for every table in the application, this would be a real mess ...

I have create a dataset that contains only the data that I want.  Now I want to display the data a field at a time.  How do I retreive the data in order to display it? I have included a code sample below:
Private Sub GetDataByEventType(ByVal AlertType)
       Dim AlertTypeData As ...

I'm loading a dataset from a cached viewstate version of the dataset created
on a previous http request.  When I read the call ReadXml on the typed
dataset, I get:
"Failed to enable constraints. One or more rows contain values violating

I have written an application that recently, under heavy load,
encountered the deadlock. After considering the time issue, I decided
to live with them. However, I have trouble reproducing them in order
to trap and handle them properly. Could someone please tell me what's

I could definitely use some help with this error!  My VB.NET 2003
program only connects to the database when the user saves, retrieves,
etc.  If they retrieve a file from the database to work on, and the
network goes down for more than about ten seconds and comes back up,

I have a SQLDataAdapter that I have configured. Since I want to tie this to
a DataGrid and add sorting to the datagrid, I do not want to configure the
adapter with sorting. I want to be able to add the sorting at runtime
depending on the column that the user clicked on the datagrid. ...

I'd like to clear up a very long-standing problem I have had only because I have done a little more testing, but the problem is still there.
On Page_Load event, the textfields on my page fills with the personal data stored in a SQL DB, as follows:
       Dim cn As SqlConnection
   ...

All,
I have an SP that takes about 5 seconds to run before any caching performed by SQL server (I run DBCC DROPCLEANBUFFERS to make sure in my tests).  
When I hook the SP into a SqlCommand object, the SP Cmd.ExecuteReader line takes about 5 seconds every time I reload the page.  ...

I have had an application where I have not been able to successully add an 'update details page' for my clients logged in to the website.
I have posted a query on this before and the result was that the WHERE clause was probably wrong; without success....but I have added a test ...

A chain letter is a "get rich quick" scheme that promises that your mail box
will soon be stuffed full of cash if you decide to participate. You're told
you can make thousands of dollars every month if you follow the detailed
instructions in the letter.

It's easy to add Columns into DataSet DataTable for example like this way
...
ds.Tables("MyTable").Columns.Add("MyColumn", GetType(Integer))
... but how can I remove this column of the DataSet which was created

Hello Group,
How can i obtain the total no of records selected with the help of
Datareader class. rowsaffected does not seem to work.
Thanks

I'm having trouble programatically inserting an Excel file into an Image column in our CRM package's SQL 2000 database.  The function appears to work ok, but when I attempt to access the file through the application's front end the file appears to be corrupt.  The front-end ...

I've got the following problem:
I need to describe a tree structure, the table in the dataset consists
of the columns structID, parentStructID, description with structID as
primary key.

ive bound textboxes in design and in code.
changes to the textboxes are reflected in the dataset, however, such changes do not get updated in the database. i have no problem with updating datagrids etc..
please advise...
thanks