I have a problem

Hi All,

I have a problem, I am building an application which involves getting some input from the user and storing the data in an oracel DB.
An insert statement should be executed whenever the user clicks the Button. the sql query is very simple, and was tested on the database successfully (out side the application).

Please have a look to the below code, and advice why it is not working

Fromthe aspx page




<asp:SqlDataSource ID="uatSupportSource4" runat="server" ConnectionString="<%$ ConnectionStrings:connectionString4 %>"


ProviderName="<%$ ConnectionStrings:connectionString4.ProviderName %>"


InsertCommand = "INSERT INTO SUPPORT ( TESTER_NAME, ACTIVITY, PROBLEM, SOLUTION, RELATED_EXCEPTION, PROB_DATE ) VALUES ( 'Mahdi7', 'Activity', 'Stam', 'again Stam', 'No Exce', TO_Date( '05/08/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'))" >





</asp:SqlDataSource>





From the VB Code:


Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click


Label1.Text = "hello world"


uatSupportSource4.InsertCommand = "INSERT INTO SUPPORT ( TESTER_NAME, ACTIVITY, PROBLEM, SOLUTION, RELATED_EXCEPTION, PROB_DATE ) VALUES ( 'Mahdi45', 'Activity', 'Stam', 'again Stam', 'No Exce', TO_Date( '05/08/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'))"


End Sub


Please advice

Post Edited By Moderator (mjp [DASP]) : 11/2/2007 10:25:02 PM GMT

 

What is the error message that you are getting. Give us the full exact copy of the error message.

 

I am not getting any error