Typed DataSet Enhancements in ADO.NET 2.0

Published Tue, Mar 29 2005 17:24 | William

One other really nice thing about the 2.0 Framework is the enhancements with DataSets.  Going to the designer, you can actually drag out a DataTable object and then add columns to it.  I know this seems like a total “Duhh” feature, but previously, I think that creating typed datasets was pretty awkward unless your dataset just happened to match the identical structure of your database table. 

>

Filed under: Data Access, Visual Studio .NET 2005

Comments

# William said on March 29, 2005 6:55 PM:

Not sure what you mean..... you could add columns in 2003....

# William said on March 29, 2005 7:09 PM:

Did you have to drag elements over and use the Element attribute? I may have just been using them incorrectly, but if you weren't dragging over a table from Server explorer, don't you have to drag an Element over, name the table, go down into the grid, set E, then columnname and then type? You have me scared b/c I may have been doing it like a dummy for the last two years ;-(

# William said on March 30, 2005 3:18 AM:

Be aware that you're still editing an .xsd file/definition. To make this a typed dataset you still have to generate code from that xsd file.

# William said on March 30, 2005 4:28 PM:

They have a fancy xml editor that keeps you in bounds of what a dataset can handle.

BTW, on the left you also have "Query", "DataComponent" .. and tonnes of other crap .. and check out the generated code in the backend .. !!!

Some serious rework over there !!

# William said on March 30, 2005 4:31 PM:

How goes it my friend? I was just about to write you an email and see how things were going ;-)

# William said on March 30, 2005 9:57 PM:

I've been working harder than a rabbit on viagra is all I can say man !!

# William said on April 9, 2005 11:18 AM:

Um, I just right click, hit add element. Then start typing (it's already at the table name). Press enter, type in a new field, select type. Repeat...

# William said on April 20, 2005 11:57 AM:

I think Load() method beats it all...

How about some other enhancements?

Indexing is said to be faster...
and you can serialize the dataset (or datatable) in binary form...

But still trying to figure how to use a typed dataset on an asp.net 2.0 surface as we did before... I want to be able to use the design time features of Typed dataset and gridview.

objectdatasource seems to be the way, but just could not figure out that yet... I dont want (and have) select, insert, delete, and update methods whatsoever...

Any ideas?