I am looking for a reliable alternatives for Visual Studio Typed DataSet
generator.
Do I have options other than VS2005 IDE for generating Typed DataSets?
I know that CodeSmith might the immediate answer, but could you referee me

I have a bit of a mystery with merging updates into dataset. Here's what
I do (roughly):
DataSet dsDelta;
dsDelta = dsOriginal.GetChanges();

Experts: Please don't suggest @@Identity to anyone without understanding and
explaining the implications of this advice. While JET is stuck with
@@Identity, it's relatively safe, but the continued use of @@Identity with
SQL Server is questionable at best. While there are some ...

I am trying to retrieve the child rows of a given DataRow using a
relationship, but sort them in the process. There are three ways I can
think of to do this:
1. Use the child table's Select() method to select rows for which the

I am inserting a record into a sql table and get two (2) indentical records
each time.  I am using a stored procedure.  What am I doing to cause this to
happen. In the stored procedure I have the line 'SELECT SCOPE_IDENTITY()'.  
The code that I use to execute the stored procedure ...

The C# & vb.net examples presented in the MS Help below are good
examples. Unfortunately, I am using a CommandBuilder as such, I do not
have access to the InsertCommand. the CB creates those behind the
scene.

I wonder if someone can help me.
I have created a stored procedure that contains a UDF in the SELECT
statement.
i.e.

Hallo Newsgroup
Ich habe ein kleines logisches problem das ich nicht allzu kompliziert lösen
möchte, deshalb wende ich mich an Euch.
Ich habe einen Dataset der alle  Daten enthält.

Hi newsgroup
I have allready posted this problem, but in german... So I try again in
english
I have a little logical problem with dataset.

I have questions on connection pooling..
1) Is a connection pool for a DB, Application or a machine?
I am using .net 1.1 and sql server 2k if that matters..
Parez

Hi there - I'm sure there is a simple answer to this ?!? - I just don't know
it...
I have several text boxes on an asp.NET web page that are used to gather
information from the user and then sent to a SQL database - they are

Can someone explain why DateTime value are not save correctly.
Here is what happen:
I put DateTime.Now in a column
Read it back and compare the Ticks values and they are off a bit.

I need to build a treeview in a winforms application. The datasource is
a dataset. I've the following tables
products(prodGUID, name)
categorys(catGUID, name, prodGUID, parentcatGUID)

I am getting following error in production for a background process:
Failed to fill Order Data Set :
Timeout expired.  The timeout period elapsed prior to obtaining a
connection from the pool.  This may have occurred because all pooled

Ok, I am done with commandBuilder.
It causes more problem than it solves:
1. Adds unecessary events, that i don't really need.
2. Can't get back AutoIncrement ID of new records.