You searched for the word(s): userid:699417

More Search Options

RSS Available

• Question and Answer application

  I'm writing a application where the user reads a question, clicks a button to see if the answer is correct. The next thing is to move to the next question. How would I do that (move to the next question) should use a loop? The questions and answers are in a database on the same row.

  Posted to Getting Started (Forum) by bthumber on 11/24/2009

• Select statement with a AND?

  I'm trying write a SELECT statement to filter out soft-deleted records: string str = "SELECT * FROM AppointmentsInformation WHERE DoctorID='" + doctor + "AND" + state=0 "'" ; But I get an error "Left side of an assignment must be a variable. state is the column heading." How do I fix this?

  Posted to Web Forms (Forum) by bthumber on 10/14/2009

• Re: Insert data into a database

  Thanks all, I found the problem...the ID column is an Identity.

  Posted to Web Forms (Forum) by bthumber on 10/10/2009

• Testing a class

  I'm trying to test methods in my class using a console application. Here is the console app. static void Main(string[] args) { // This has two overload. AppointmentClass ac = new AppointmentClass(); int first = 0; string date = "10/9/09"; string city = "Buffalo"; string foot = "foot"; string dr = "Dr. Foot"; int distance = 20; string meds = "none"; //int state = 0; ac.InsertAppointment(0, date, city, foot, dr, 20, meds); Console.WriteLine("

  Posted to Getting Started (Forum) by bthumber on 10/9/2009

• Re: Testing a class

  CommandType is not needed because I passed the string to the command.

  Posted to Getting Started (Forum) by bthumber on 10/9/2009

• Re: Testing a class

  I sure did, the last line is running and I'm getting any exceptions...should I???

  Posted to Getting Started (Forum) by bthumber on 10/9/2009

• Re: Testing a class

  Yes, I'm sure about the connection. I'm not getting any errors.

  Posted to Getting Started (Forum) by bthumber on 10/9/2009

• Re: Testing a class

  How can I test to see if I'm handling the exception correctly, also do you see anything worry with code in the class or the console app?

  Posted to Getting Started (Forum) by bthumber on 10/9/2009

• Re: Testing a class

  So, by looking at the code I should be throwing an exception? How do I improve my catches?

  Posted to Getting Started (Forum) by bthumber on 10/9/2009

• Re: Testing a class

  Ok, now get an error "Sql Error on insertion"

  Posted to Getting Started (Forum) by bthumber on 10/9/2009