Recent content by JJ297

Thanks.

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

Thanks I got it working!

I tried that now I'm getting and error: NullReferenceExpection was unhandled by user code object reference nto set to an instance of an object. Use the "new" keyword to create an object instance. Any ideas?

Thanks for this but I'm a newbie and don't know what I should put in place of Dim conn As New Data.SqlClient.SqlConnection("Data Source=seb2a54;Initial Catalog=SpdtLibrary;User ID=Training;Password=people") Should I put... Dim conn As New Data.SQLClient.SqlConnection =...

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")

Thanks, I've figured it out.

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

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

Thanks George it worked!

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

Thanks to you both for having patience with me. You fixed my problem.

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

Thanks that worked I found the problem!

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