Please help!!!!

Hi All,


I need an urgent help....
For god sake, can someone tell me what is wrong with the following function???

1. The Insert Statement was tested successfully with oracle and with the .NET Wizard.... But whenever I click the Button4 from the application nothing happens... what is wrong with this InsertCommand???

Please help... what I am missing here!!!!

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



Label1.Text = "hello world"


uatSupportSource4x.InsertCommand = "INSERT INTO SUPPORT(TESTER_NAME, ACTIVITY, PROBLEM, SOLUTION, RELATED_EXCEPTION, PROB_DATE) VALUES ('Karkar', 'Wahbi', 'Hiba', 'Omima', 'Adham', TO_DATE('05/08/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'))"


Thanks in Advance for saving my Job,

 

Assuming uatSupportSource4x is SqlDataAdapter ,try something like:

Dim insertquery As string='INSERT INTO SUPPORT(TESTER_NAME, ACTIVITY, PROBLEM, SOLUTION, RELATED_EXCEPTION, PROB_DATE) VALUES ('Karkar', 'Wahbi', 'Hiba', 'Omima', 'Adham', TO_DATE('05/08/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'))'

uatSupportSource4x.InsertCommand = New SqlCommand('insertquery',yourconnection) where 'yourconnection' is your connection string.

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

uatSupportSource4x is the sqldatasource.

Regards,
Mahdi

 

You need to call the insert method in your code. something like:

uatSupportSource4x.InsertCommand='...' will only assign the value to the InserCommand property.Use the above method to invoke the InsertCommand.
uatSupportSource4x.Insert();

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Vikra....





I have to say that you are great


Thanks you.... It worked