Recent content by ace333

getting the following error now 12:10:28.586 [Microsoft][ODBC SQL Server Driver][SQL Server]An explicit value for the identity column in table 'ITRRComments' can only be specified when a column list is used and IDENTITY_INSERT is ON.(23000,8101) Procedure(InsITRRComments)

This error now, what have i missed [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@CommentId'.(42000,137) Procedure(InsITRRComments) CREATE PROCEDURE dbo.InsITRRComments /** @CommentId int IDENTITY,**/ @DacType varchar(25), @DacTypeId...

This is my stored procedure and it gives the following error, I'm new to sql server stored procs so I'm sure its some basic error... Incorrect syntax near the keyword 'IDENTITY'.Procedure(InsITRRComments) CREATE PROCEDURE dbo.InsITRRComments @CommentId int IDENTITY, @DacType...

I have an application that reads data from a database, wraps the data in html table tags and then sent as an email to myself. My problem is as follows. I have set the email format to be html so when I open the email I should see the data in a nice table format. That does not happen however. The...

do i need to set up an smtp server on iis to send the emails, do u know how to do this

This is my email code, how do i adjust to html format MailMessage mail = new MailMessage(); mail.To = "xxxxxx";//txtTo.Text; mail.From = "xxxxxxx";//txtFrom.Text; mail.Subject = "test"; //txtSubject.Text; //mail.BodyFormat. //Set the BodyFormat =...

using System.Web.Mail; is at the top but i need to be able to find the dll to add it to the project,, can u elaborate on what u mean cheers

cheers, i found some code that uses the name space using System.Web.Mail; where can i find this dll if its not on my pc

1. I'm querying a database that brings back rows of data 2. I wrap the data in html so it has a table structure Q. What I want to do is send the table in the body of an email .... I'm gona google it but any suggestions before that would be great

The following query wont work because GO needs to be on a separate line, is there a way I can force a new line in there. I can use a stored proc because I am joining a few tables together.... I want to force sql server to treat SET ANSI_NULLS OFF GO SELECT.... on separate lines SET ANSI_NULLS...

i figured out the problem, i was testing the sql code using db artisan but the server was a sql server so the following was needed in front of the query SET ANSI_NULLS OFF GO http://www.awprofessional.com/articles/article.asp?p=25288&seqNum=8&rl=1

I have the following problem. I am trying to execute a rather complex sql statement. The first sql statement below returns the desired rows, the second one wont return anything. Both sql statements work perfectly when run from the database. I dont understand why the second sql says that nothing...

Try to run it again and its taking ages, now i'm really confused, its been hanging for about 15 minutes

this is so weird, after about 10-12 minutes the application has given back the result I wanted I think, surely it should be faster !!!

using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using Derivatives.ops.lib; using...