|
||||||||
|
Now working with large amounts of data that must be exported, transformed and imported, DTS Services are being utilized:
I think that article is actually sourced here (better page, slight differences in code): Automate data transfers with SQL Server and VB.NET
My wife found this site by looking at the source code of another site for other reasons, and we’ve dug into it finding tons of useful code, scripts, and concepts!
Search This Site!This is a great site search — it uses a temporary MySQL table to cache data, so it’s fast, it automatically updates when appropriate, so it stays accurate. It’s only downside that I see is that, by default, it has a minimum word length of 4 characters, so, for instance, searching for "php" would find no hits! Sheesh! It’s actually a "feature" of MySQL, though:
Too often, hosts don’t provide enough control over the server to make features like this useful, but MeWebHost.com is great! While I was not able to make this adjustment myself, they were very helpful, and did it for me! Â http://www.theserverside.net/tt/articles/showarticle.tss?id=DataSetDesigner
October 13, 2005 A good data access layer is critical for most business applications, whether that layer resides on a middle tier application server, a web server or on the client. Data access layers tend to involve a lot of error-prone, repetitive coding if you try to do it by hand. You can alleviate some of that by designing a good set of base and helper classes to encapsulate the repeating patterns, or by using a code generation tool. However, you still usually have to write all the data access methods by hand for the ad-hoc queries that service large parts of your application. SummaryWhen building a web application creating the DAL should be one of your first steps, occurring before you start creating your presentation layer. With Visual Studio, creating a DAL based on Typed DataSets is a task that can be accomplished in 10-15 minutes without writing a line of code. The tutorials moving forward will build upon this DAL. In the next tutorial we’ll define a number of business rules and see how to implement them in a separate Business Logic Layer. Â http://www.joelonsoftware.com/articles/fog0000000245.html Painless Software SchedulesBy Joel Spolsky |
||||||||
|
|
Generally, however, I am disappointed that the Visual Studio 2005 does not have any newer/better pure .Net way of doing this; it still involves accessing the IE components via COM.
I’d like to make this a good master list of articles and methods, so if you have any useful contributions, please feel free to leave me comments!
–Gon
This is a very useful looking article by Scott Mitchell, on 4GuysFromRolla!
http://www.4guysfromrolla.com/webtech/071906-1.shtml
This document contains the specifications and descriptions for the MDIT Patient Information Module.
This zip file contains the generalized templates for each of the modules of MDIT:
Please see subsections for specifics regarding each individual module.
Recent Comments