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 Rhinorhino 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: JJ297
  • Content: Threads
  • Order by date
  1. JJ297

    Clearing text box

    Could someone tell me how do I clear the text box after hitting the submit button? I have the page posting back to itself.
  2. JJ297

    Web config

    Could someone tell me how to reference my datasource from web config in my code behind page. I have this displayed now which is giving out too much info: Dim conn As New Data.SqlClient.SqlConnection("Data Source=seb2a54;Initial Catalog=SpdtLibrary;User ID=Training;Password=people")
  3. JJ297

    Validating check box

    Can't get null into the database. I'm trying to achieve... if displayedQues = "Y" then I want nondisplayedques to go into the database as null. What do I need to do? This is what I have thus far. Dim displayedQues As Char = "Y" Dim nonDisplayedQues As Char = "N" If...
  4. JJ297

    Validation check box

    Could someone please help me I can't get null into the database. I'm trying to achieve... if displayedQues = "Y" then I want nondisplayedques to go into the database as null. What do I need to do? This is what I have thus far. Dim displayedQues As Char = "Y" Dim nonDisplayedQues As...
  5. JJ297

    stored procedure question

    Could someone please assist me... I'm trying to get all records in the database that displayedques = 'y' and displayedques = null. This is my stored procedure but it's not returning what I want. select QuesNAns.questions, QuesNAns.answer, QuesNans.displayedques, topics.topicid from...
  6. JJ297

    Help using 2 stored procedures on the page behind

    Can someone tell me why I am getting: Procedure or function AddRequestorInfo has too many arguments specified. Here's my code. I'm trying to use two stored procedures. Do I have it set up properly? Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles...
  7. JJ297

    Application Exception Error message

    Could someone tell me what I'm missing in my code, when I hit the submit button to add the question to my database I get... FINALLY Application Execption was unhandled by usercode, an error occurred while trying to insert the record. I have a text box on the aspx page <asp:TextBox...
  8. JJ297

    Need help writing an If statement

    Hello I'm a newbie to programming and need help writing an if statement. Is this the correct forum? I have a database set up in SQL with the following fields: Category Questions Answers I only want one category to appear for all of the questions and answers submitted for that...
  9. JJ297

    Need help writing an If statement

    Hello I'm a newbie to programming and need help writing an if statement. I have a database set up in SQL with the following fields: Category Questions Answers I only want one category to appear for all of the questions and answers submitted for that category. The way I have it...
  10. JJ297

    hitting submit button and a generated email is sent

    I'm having problems with my code. Can somone take a look and tell me what I've left out? Thanks! Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim objEmail As New System.Net.Mail.MailMessage() objEmail =...
  11. JJ297

    SQL Question

    Hi I'm a newbie and want to know if someone can help me to get the correct data out of my table. I've merged two tables but only want the topic listed one time and have the right questions and answers underneath those topics. Here's my code: select topics, questions, answer from topics AS A...
  12. JJ297

    Need help writing a for each loop

    Can someone help me write a for each loop? I'm using a data reader to read three fields I have in the database: Topics, questions and answers I would like to use a for each loop (or whatever is best) to get all topics from db and have all questions and answers pertaining to that topic...
  13. JJ297

    Need helping writing a for each loop

    I'm a newbie and looking for help in writing a for each loop in .Net. The fields are Topic, question and answers. I'm trying to have only one topic listed and then the right questions and answers underneath each topic. Can someone please help?
  14. JJ297

    Loops

    Hi, I'm a newbie to sql programming and need some assistance in trying to get Topics, questions and answers from a database. I want Topics on one line, then the question that goes with that topic and answer on the lines underneath. How do I code this? I'm grabbing the data with a data...

Part and Inventory Search

Back
Top