Recent content by dragonwell

Thanks for all your posts on this. We decided to update the application code to use SCOPE_IDENTITY(). :-)

I added an AFTER INSERT trigger to a table. Unfortunately, some application code is using @@IDENTITY to get back the value of the identity column from that table. The trigger does an insert into another table, so @@IDENTITY returns the identity value from that second table and breaks the app...

Looks like a good book... Thanks _______________________________________

In all examples of the Decorator pattern I've seen, for example : http://www.dofactory.com/Patterns/PatternDecorator.aspx, the functionality being extended is on a method with a void return type. So it's easy to see how one could add additional functionality before or after passing the...

I prefer notebook and pen! ;-) _______________________________________

Make sure ViewState is not disabled for the page or the DataGrid. _______________________________________

Do you have ViewState enabled?

I've been using it a lot and I like it (haven't written a single line of javascript yet!). We are replacing a desktop app with a web form and it's essential that the users have a postback-free experience for the most part. AJAX is turning out to be essential for this. In addition to the basic...

Hi, warning -the logic here may be flawed (I'm tired...) I'm trying to create a sp to search a catalog database. The view I'm querying has columns like item-name, size, color, description, etc. I want the user to be able to submit a search string like 'small red shoe' and return only...

Also keep in mind that there are quite a few different code-generation and object/relational mapping frameworks out there for .NET that make stuff like this pretty easy. For example, there are at least half a dozen free code generators that look at your database schema and generate all the...

Thanks for all the replies. I really like the actor/surgeon analogies. Since starting this thread I've not gotton any better at context switching, but the just awareness of it and recognizing it when it's happening helps somehow. _______________________________________

I found a couple articles that support my feelings on "Context Switching" - that is, having to stop what you're doing to do something else (even for five minutes) costs you orders of magnitude more than five minutes of time wasted. The first, from Joel...

I think Server.Transfer expects a virtual path (url), not an actual instance of a page object. What you can do is place your variables that you want to pass along into the current HttpContext, and they will be available in the code of the page you transferred to...

There are a couple of O/R Mappers that I know of that fully support stored procs: iBATIS and the Wilson ORMapper. I like Wilson because by default it uses dynamic sql but you can override this and use stored procs whereever necessary. With iBATIS I am pretty sure you have to write all your...

Good point, Gil. This sounds like what the domain driven folks call ubiquitous language.