Recent Posts

Calendar

April 2014
S M T W T F S
« Mar    
 12345
6789101112
13141516171819
20212223242526
27282930  

datasets

Swapping Out the DAL

One of the comments that showed up on the blog post about using 3-tiered with DataSets and the ObjectDataSource was, “How do we set this up so that we can swap out the DAL?”  The simple answer to this is, “roll your own Table Adapter.”

DataSets, TableAdapters, and Transient Retry Logic For SqlAzure

ppl-men-055The main project I’m working on these days is moving several web sites to Azure.  It is something I’ve wanted to be able to try for a while.  I’m working with several other agencies on this project and some Microsoft consultants so there is some good guidance along the way.… Read the rest

One Form with Multiple Tables

B01I0093 I received the following question a few days ago:

“I am trying to use three tables from the same dataset in one form that I am creating in vs.net winforms my problem I guess is the setup of it as I can get them all on the form but cant get them to all post to the separate tables when I click save I am using a mysql database with the Mysql connector not the obdc can this even be done?”

Frustrating, isn’t it?  .NET makes some things SO easy, and then when it isn’t you figure you must have done something wrong.… Read the rest

Silverlight – Databinding to a Web Service

misc_vol1_049 In the last several posts, I’ve demonstrated various ways of getting data onto the screen.  What I’ve purposely omitted up until this point is how to update this information.

So let’s start by going back to the demo we created in Febuary.… Read the rest

Silverlight, Web Services and Datasets

G05B0037 I sat down today to learn about using Silverlight and Dataset from a Web Service.  Something you’d think would be rather trivial.

I mean, seriously folks.  We use Datasets as a means of transporting data up and down the tiers of just about everything we do in .NET.  It would stand to reason that using DataSets as our transport mechanism in Silverlight would be a given.… Read the rest