Geeks With Blogs
New Things I Learned August 2008 Entries
Returning Cursor from Stored Procedure Executing Dynamic Query
I usually stay on the C# development of things, and rarely venture to create SQL statements/code, other than the occasional SELECT / UPDATE / INSERT. However, we have a requirement from our Product Management group to DELETE records permanently from the database. We have proper enforced foreign keys in our DB schema, so one option we have is to create a stored procedure to help deletion, which will walk thru the referencing foreign keys to the record being deleted and then also delete those records ......

Posted On Tuesday, August 26, 2008 11:49 AM

Refresh / Update WPF controls
Sometime in the past, a friend asked me how to update a control to show status while his code is doing a loop of stuff. Essentially changing the text of a label (or sophisticatedly we can say a text-based progress bar). In my past coding with MFC and WinForms, it's fairly easy enough, you just invalidate and do an update (Invalidate / UpdateWindow in MFC or Invalidate / Update in WinForms). This approach also coincides with how Windows UI operate, where you specify the region that needs to be redrawn ......

Posted On Monday, August 25, 2008 10:22 AM

Calling Generic Method when given a type
Every now and then I have a need to call a generic method, but I can't quite call it generically. Usually that particular situation involves needing to call a generic method, and I have the type for that generic method. There are various reasons/examples of why anyone would get to this point, in my case we have an infrastructure code that can deal with objects generically, but because it is infrastructure code, we can't have it refer to the actual entity classes that are in the higher layer/tier. ......

Posted On Friday, August 22, 2008 9:41 AM

Copyright © Muljadi Budiman | Powered by: