I've just updated my last GDN sample to v1.1 with more stuff after the feedback I've got since my last post about it . I've listened to Robert McLaws and implemented support for handling one-to-many relationships and many-to-many aswell. The DataControls support TextBox, CheckBox, DropDownList and CheckBoxList...

I've just released a new version of my DataPanel on GotDotNet. Anyone who have ever made a ASP.NET dataentry web form with a lot of textboxes for editing data in a lot of columns know it's a tiresome task. You have to set all the Text properties on load with the column values, and put updated values...

I've just finished setting up my new Dell D600 notebook, and as always surprises occur. I was about to edit my typed dataset XSD file when nothing happened in VS.NET 2002. The XSD designer would not open. I then tried to add a new dataset to the project to manually move the schema. Then I got this nice...

If you look up the DataRow class in the .NET Framework documentation you'll see this: [Serializable] public class DataRow In the happy beleif that this was entirely true I designed my remoting interfaces with DataRow as parameter and return values to transport DataRow objects standalone. But no. I got...

Erik fights for the removal of [TableName] from primarykey-names and sets an equal sign between Table and Class. His point about the ID field seems ok, but as I see it, this all boils down to setting a standard and keeping it. In my opinion the naming in the database is somewhat irrelevant because I...

Yesterday I decided to fiddle around with MS Visio for Enterprise Architects database modelling tools. After drawing up and validating a pretty straight-forward use case i created a new Database Model Diagram Template from visio. After telling Visio to use the Sql Server ODBC driver I got all the Sql...

Yup. That's right. You've been a good boy (or girl) and annotated your typed dataset XSD with codegen:nullValue attributes to instruct the codegenerator in how to handle DBNull values. And you actually thought the MSDataSetGenerator would care? Well it does, if you add the minOccurs="0" aswell. Otherwise...

Ever wondered how to construct multitable DataSets in a proper manner? Whether to use one dataadapter or several? Just found this one on MSDN: Navigation Multiple Related Tables in an ADO.NET Dataset To make it even better use Annotations in the XSD file to improve the syntax of the generated code. Explained...

Andres stepped up quickly with some hints to my previous blogentry . I tried out the ADO.NET Powertoys which contained several features. Because it was poorly documented, and I just needed one of the features, I think I'll wait for a later release. I could have given DeKlarit a shot, but I simply like...

I've just updated my last GDN sample to v1.1 with more stuff after the feedback I've got since my last post about it . I've listened to Robert McLaws and implemented support for handling one-to-many relationships and many-to-many aswell. The DataControls support TextBox, CheckBox, DropDownList and CheckBoxList...