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