I wanted to direct everyone to some links that came up over the weekend. The first is a link from Scott Gu's blog. SSW has released some pretty extensive coding standards. Check them out here. I consider myself a good developer, but I know I have a lot to learn, as does a good portion of the industry. Second, there has been some news about Microsoft releasing their internal documentation compiler, Sandcastle. Check out their MSDN Blog and download the first CTP. Also, I'm working on a test skin for...
Things have been a bit crazy the last couple of days (my wife is pregnant and there have been a few complications), but I wanted to share some links I've come across the last couple of days: Video - Visual Studio 2005 for Database Professionals (MS Channel 9) Implementing Role Based Security with ASP.NET using Windows Authentication and SQL Server (From ScottGu's Blog) Free web site templates - Open Source Web Designs Chris Technorati : .NET, ASP.NET, Database Professionals, Microsoft, Open Source,...
I'm not a DTS wizard by any means. I don't use it a whole lot, and always consider writing a program to move data around instead (Although I rarely do since DTS is usually quicker and can be set up pretty quickly) since I don't find it very intuitive. When I needed to move a list of users from one database to another, either inserting if they didn't exist, or updating information if they did, I wanted to see if DTS had a simple solution. Now I had to do a lot of searching online before I figured...
Introduction This article covers an application that was written as a “Proof of Concept”, testing the ability to trigger the launch of an application from a web application. The application is also a bit of a practice in Remoting, a subject that I have not explored very much. The application is intended to work within an Intranet environment as it would not work correctly within an Internet environment. In addition to the main subject, it covers creating remoting proxies to different...
Introduction I’ve been asked on several occasions to export data in a format that can be easily loaded into Excel or parsed by a simple application. CSV is an excellent format since it’s widely recognized and supported by Excel. In this article, I’ll provide a simple way to build a string containing the data in CSV format. As a bonus, I’ll cover saving the returned string to a file and include the application that I originally wrote the code for. The Code Below you will find...
Introduction Among the many changes to .NET in 2.0, there was an overhaul of the classes for sending E-Mail. For those of you unfamiliar with the new System.Net.Mail classes, or those of you trying to send mail for the first time, this article is for you! I’ll be specifically targeting sending mail through Exchange, so you may need to make some small changes if you’re using another type of server. What has changed? The most obvious change to sending mail in VS 2005 is that the classes...
Introduction This 3 article series will cover inserting data into SQL Server, without the help of Visual Studio’s drag and drop controls and configuration wizards. A special emphasis will be placed on its application within a tiered environment. Part 1 – Part 2 – Part 3 Part 3 – Executing the Insert Now that we’ve covered creating a stored procedure and creating a connection to the database, we’re about to get to the most important part of this article –...
Introduction This 3 article series will cover inserting data into SQL Server, without the help of Visual Studio’s drag and drop controls and configuration wizards. A special emphasis will be placed on its application within a tiered environment. Part 1 – Part 2 – Part 3 Part 2 – Creating a Connection Now that we have a stored procedure, we need to be able to connect to our database. I’ll cover a brief overview of a SQL connection string, some basics about the SqlConnection...
Introduction This 3 article series will cover inserting data into SQL Server, without the help of Visual Studio’s drag and drop controls and configuration wizards. A special emphasis will be placed on its application within a tiered environment. Part 1 – Part 2 – Part 3 Part 1 – Creating a Stored Procedure While inline SQL may be an easy way to access databases, it’s far from ideal. Stored procedures are the recommended method of SQL Server access. They protect you from...