http://p2p.wrox.com This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 by Chris Hart, John Kauffman, David Sussman, Chris Ullman; ISBN: 9780764588501 Read more about Beginning ASP.NET 2.0 or buy the book from your favorite retailer Download the code for Beginning ASP.NET 2.0 en Sat, 21 Nov 2009 19:09:49 GMT vBulletin 60 http://p2p.wrox.com/images/misc/rss.jpg http://p2p.wrox.com http://p2p.wrox.com/book-beginning-asp-net-2-0-book-vb-isbn-978-0-7645-8850-1-c-isbn-978-0-470-04258-8/77084-sending-email-user-causes-error-sqlexception-0x80131904.html Thu, 19 Nov 2009 10:53:15 GMT A severe error occurred on the current command. The results, if any, should be discarded.

Stack Trace:
[SqlException (0x80131904): A severe error occurred on the current command. The results, if any, should be discarded.]

This error is being generated when my ASP.NET 2.0 program calls a stored procedure, which sends the user an email when a new record is created. However the email is sent with no problem.

Have searched through lots of sites, but have found no solution.

The SQL Server stored procedure is as follows:

CREATE PROCEDURE dbo.spCreateLessonSendEmail
(@Receiver varchar(100),
@LessonID int)
AS
DECLARE @MessagePart varchar(45)
BEGIN

set @MessagePart = 'You have just created a new Record ID#=' + cast(@LessonID as varchar)

exec [MAILSERVERADDRESSmaster.dbo.xp_sendmail
@Recipients = @Receiver,
@Message = @MessagePart,
@Subject = 'New Record Created'


END
GO

In the ASP.NET page itself the procedure is being called through the following code:

Sub Run_spCreateLessonSendEmail()

Dim myConnection As New System.Data.SqlClient.SqlConnection(strConn)
myConnection.Open()

Dim myCommand As New System.Data.SqlClient.SqlCommand("execute dbo.StoredProcedure 'recipients.address'," + Session("Session_LessonID").ToString, myConnection)

myCommand.CommandType = Data.CommandType.Text

Dim reader As System.Data.SqlClient.SqlDataReader = myCommand.ExecuteReader()

myConnection.Close()

Server.ClearError()

End Sub ]]> BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 Paul Carter http://p2p.wrox.com/book-beginning-asp-net-2-0-book-vb-isbn-978-0-7645-8850-1-c-isbn-978-0-470-04258-8/77084-sending-email-user-causes-error-sqlexception-0x80131904.html http://p2p.wrox.com/book-beginning-asp-net-2-0-book-vb-isbn-978-0-7645-8850-1-c-isbn-978-0-470-04258-8/77043-shopping-cart-paypal.html Sun, 15 Nov 2009 19:42:04 GMT Since the ecommerce example in the book doesn't really go into detail on how to build a fully functional ecommerce application, has anyone adjusted it to send the contents of the shopping cart to paypal for checkout, so the user can checkout there? If so, could you provide the necessary code adjustments/additions to accomplish this?

Also, I'm using C#.

OR can anyone at least provide a tutorial or another book that tells how to finish building this store (based on the same code). I have a cart, but no way to activate SSL, connect to a merchant to process card, send confirmation email or clear the cart upon a successful purchase. ]]> BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 selliott http://p2p.wrox.com/book-beginning-asp-net-2-0-book-vb-isbn-978-0-7645-8850-1-c-isbn-978-0-470-04258-8/77043-shopping-cart-paypal.html