magic. cheers.

Quick question... i'm feeling a bit thick today... Does... Begin Tran stored procedure 1 stored procedure 2 stored procedure 3 rollback ...work? ie are the contents of stored procedures also rolled back?

thats nothing to do with the value of the product you are offering

how much it cost to build the product does not determine how much the product is worth. its all about demand...

not the most fun in the world debugging, as i'm developing a windows service; at System.Net.Mail.MailCommand.CheckResponse(SmtpStatusCode statusCode, String response) at System.Net.Mail.MailCommand.Send(SmtpConnection conn, Byte[] command, String from) at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception) at System.Net.Mail.SmtpClient.Send(MailMessage message) at TransactionService.ServiceMain.importLogic_DataAccessSQLException(Object sender, ChainStoreTransactionImportExceptionEventArgs e) at BusinessLogic.ChainBranchTransactionLogic.OnDataAccessSQLException(Object sender, ChainStoreTransactionImportExceptionEventArgs e) at BusinessLogic.ChainBranchTransactionLogic.ChainStoreTransactionImport(EPOSTransactionDataSet transactionDataSet) at TransactionService.ServiceMain.ProcessTransactionFiles() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()

Out of interest, here is my call stack, I dont think there should be an issue but if you do could you let me know, thanks again! at System.Net.Mail.MailCommand.CheckResponse(SmtpStatusCode statusCode, String response) at System.Net.Mail.MailCommand.Send(SmtpConnection conn, Byte[] command, String from) at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception) at System.Net.Mail.SmtpClient.Send(MailMessage message) at TransactionService.ServiceMain.importLogic_DataAccessSQLException(Object sender, ChainStoreTransactionImportExceptionEventArgs e) at BusinessLogic.ChainBranchTransactionLogic.OnDataAccessSQLException(Object sender, ChainStoreTransactionImportExceptionEventArgs e) at BusinessLogic.ChainBranchTransactionLogic.ChainStoreTransactionImport(EPOSTransactionDataSet transactionDataSet) at TransactionService.ServiceMain.ProcessTransactionFiles() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()

my thoughts every single time i've considered mac

correct. upgrade to xp. *waits for masses of abuse

haha thanks :)

It is indeed , i intend to use Exception ex once i can actually catch the exception!

it definately isnt being caught :(

Interesting. This is occuring in an event handler, however i thought the method which triggers the event should be on the same thread. I'll look into it as there is some SQL data access going on which may make and asynchronous call. Thanks!

try
{
smtpClient.Send(mailMessage);
}
catch (Exception ex)
{
eventLogImport.WriteEntry("SMTP Email error: could not send email.", EventLogEntryType.Warning);
}

Hi, The above code still throws an unhandled SMTPException when smtpClient.Send is called. SMTPException is derived from System.Exception so should it not be caught? Thanks

that sucks. poor guy.

Have you eliminated this guy or have you opened/freed up a resource (ie him) to be used elsewhere?

Here's one for anyone to look out for in the future (i feel like an idiot) the Description Column should really have been the "Name" column therefore when i loaded the results into the dataset the name column was blank and the description colum was created thanks for your help! A very tired but enlightened Blakey404

I've just had a brainwave... This datatable is populating a combobox, directly via databinding (datasource, datavalue etc) To clear the combo box i am setting it's index to -1... could this or something else related to the combobox be inserting my extra column? i bet it is. crap that's going to be fun to find.

This is the strangest thing... That is exacly what my query looks like, its in a stored procedure. When i populate the datatable the three columns are there and correct... its only when i create a dataview or use .Select that the extra colum is inserted into my results!! i'm at home now but i will connect to work later on and give a code example... cheers for the reply

idiots like you also mean my post has been pushed off the front page

idiots like you also mean my post has been puched off the front page