Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ace333
  • Order by date
  1. ace333

    problem with identity in stored proc

    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)
  2. ace333

    problem with identity in stored proc

    ...Driver][SQL Server]Must declare the variable '@CommentId'.(42000,137) Procedure(InsITRRComments) CREATE PROCEDURE dbo.InsITRRComments /** @CommentId int IDENTITY,**/ @DacType varchar(25), @DacTypeId int, @TypeOfComment varchar(50)...
  3. ace333

    problem with identity in stored proc

    ...@UserId varchar(25), @FullUserName varchar(50), @AmendedDateTime datetime, @ProcessedFlag char(1) AS BEGIN /************************************************************************* * * Name: InsITRRComments * * Description: Insert...
  4. ace333

    Problem sending an email c#

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

    Sending an email

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

    Sending an email

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

    Sending an email

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

    Sending an email

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

    Sending an email

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

    query issue

    ...from SecurityUsers where UserId = D.AmendedByUserId) FullName, D.AmendedDateTime from dbo.ITRR_RCRFDetailComments R, RCRFDetail D where R.Id *= D.Id and R.AmendmentInstructions *=D.AmendmentInstructions and R.AmendmentInstructions not in ('', NULL) union select '1' as CommentId,'RCRF'...
  11. ace333

    Problems with data reader...........

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

    Problems with data reader...........

    ...string strConn = ConfigurationSettings.AppSettings.Get("ConnectionString"); con = new SqlConnection(strConn); string sql=""; /**THIS WORKS... sql =" select 'RCRF' as DacType, R.Id, R.AmendmentInstructions as Comments, 'Comment' as TypeOfComment, D.ExternalID as...
  13. ace333

    Calling a function inside a while loop

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

    Calling a function inside a while loop

    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 !!!
  15. ace333

    Calling a function inside a while loop

    ...TraceHelper("AppTrace", ""); //[STAThread] //static void Main(string[] args) public static string test() { string er="nnn"; ///** try { //string strConn = SecurityConfig.GetVersionSetting("DacConnection"); //Initial Catalog=Dacari;Data...
  16. ace333

    Calling a function inside a while loop

    I am calling a method inside a for loop and the problem is that the method calls another method. There is nothing wrong with the method if its called as a one off, it works fine but inside the loop the page just hangs. The loop is going to iterate about 1300 times and the method called calls...
  17. ace333

    connecting to sql server using c#

    ignore that last point, i cant connect both ways but i cant login either way even though i can query the database through the sql server query analyser can anyone help.... have went through the steps above and been looking on google for the last day ....
  18. ace333

    connecting to sql server using c#

    Another thing to add, I can connect to the database by doing it visually through using the server explorer. If I do it that way how do I bring back data and add it to a database. Its strange that i can connect to the server this way but not any other.
  19. ace333

    connecting to sql server using c#

    I wonder is it related to the settings on my computer, I'm using Microsoft Development Environment 2003 Version 7.1.3088 and Microsft SQL Server Version 8.00.194
  20. ace333

    connecting to sql server using c#

    ya but i have tried all of this already.... thanks for your help anyway, i'm just going to go home and look at it with a fresh head in the morning

Part and Inventory Search

Back
Top