
August 30th, 2012, 03:27 PM
|
|
Registered User
|
|
Join Date: Jun 2012
Posts: 5
Time spent in forums: 21 m 26 sec
Reputation Power: 0
|
|
|
Error in Inserting the Date + ORACLE
Code:
Imports System.Globalization
Imports System.Data
Imports Oracle.DataAccess.Client
Partial Class _Default
Inherits System.Web.UI.Page
Dim con As New OracleConnection("Data Source=XE;User Id=user_test;Password=sarvagya;")
Dim cmd As New OracleCommand
Dim da As OracleDataAdapter
Dim ds As DataSet
Dim query As String
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
query = "Insert into Practise2 values(:DOB)"
cmd = New OracleCommand(query, con)
Dim formats As String() = {"dd/MM/yyyy", "d/M/yyyy"}
Dim dt As DateTime
cmd.Parameters.Add(":DOB", "TO_DATE('18/07/2011','dd/mm/yyyy')")
If con.State = ConnectionState.Closed Then
con.Open()
End If
cmd.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.Message)
Finally
If con.State = ConnectionState.Open Then
con.Close()
End If
End Try
End Sub
End Class
When I run the Code I get the ERROR message
a non-numeric character was found where a numeric character was expected.
|