.NET Answers
ASP.NET, HTML, CSS, Visual Studio, CSharp, VB.NET and other programming items of interest.

There are cases where it is advantageous to have a separate sql login for each user login who will be editing your database.  If you are using Windows authentication, this is not a problem because you can pass the windows authentication tokens on through to the db without having to do a whole lot of work.

But, what about times where setting up a separate windows user for each person who will be accessing the system is more work than it’s worth, or as is the case in shared hosting plans, just isn’t practical?

(more…)

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

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.”

(more…)

Last Friday I showed how to use DataSet, the ObjectDataSource and select statements.  Today, I’ll start with the project we ended up with last week and convert it to use stored procedures instead and I won’t write any code.  That is, only the DataSet is going to change.  The rest of my code will stay exactly the same as it was when we started.

(more…)