yes,
make an html template and use the file system object to read the html text of that template to a stream and save it as a string. use that string as the body of the email.
hard to say without seeing what readtag does, but in this view, we aren't seeing any file exists checking.. are you doing any checks on this? have you debugged and stepped through to make sure that the full path is going to the function ok?
Been there..
I actually got so tired of buying books that were not hitting on the points that I needed to wrap my head around that I just went to videos instead. Now those books make more sense.
http://www.microsoft.com/events/series/msdnwebdev.mspx...
A lot of the drag and drop things out there like table adapters generally break basic rules of coupling by bringing your DATA layer up to your presentation layer which is a big no no. They're great for proto-typing an application so you can say.. lets do this and it should do this and look like...
Views are like "virtual" tables if you will. They are good for "hiding" things from developers.. Lets say a devleoper wanted to get Personnel info for a front end display.. the DBA can refuse access to the table directly and offer a view that only shows pertinant information to the developers...
When I showed up my first day at College (we call it College in the US), I wasn't scared one bit. I was a bit frustrated at the disorganization of everything but I showed up like I owned it and people ended up asking me what to do. I ended up making a lot friends on the first day because I was...
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
Create PROCEDURE [dbo].[InsertOrder]
(
@CustomerID Int,
@PaymentTypeID Int,
@PickupLocationID Int,
@NumberOfPayrollDeducts Int
)
AS
BEGIN TRANSACTION
Set NoCount On
Declare @OrderID Int
-- INSERT the new Order
INSERT INTO...