I am trying to add null value in my oracle database but its not Inserting any record, not even inserting null value and not throwing any error also...
Please, help...
Dim
sqlStmt As String
Dim conString As String
Dim cn As OracleConnectionDim cmd As OracleCommandDim sqldatenull As OracleDateTrysqlStmt =
"insert into temp (startdate, enddate) Values (@startdate, @enddate)"'conString = "server=localhost;database=Northwind;uid=sa;pwd=;"conString =
cn = New OracleConnection(conString)
cmd = New OracleCommand(sqlStmt, cn)
"Data Source=abc; User Id=abc;Password=ab"cmd.Parameters.Add(
cmd.Parameters.Add(New OracleParameter ("@enddate", OracleDbType.TimeStamp))sqldatenull = oracledate.null
If
New OracleParameter ("@startdate", OracleDbType.TimeStamp))cmd.Parameters(
'cmd.Parameters("@Date").Value = DBNull.ValueElse
"@EndDate").Value = DateTime.Parse(txtEndDate.Text)
"@EndDate").Value = sqldatenull
Loading
jimmy shownPosted Mar 7, 2011, 11:52 PM
"String was not recognized as a valid DateTime."...
Is there any waythat you can take a look in my code and give me some input....
I am able to insert record for start date and end date but when i am trying to insert just start date and leave blank for end date then I am getting an error...."String was not recognized as a valid DateTime."...
Little help, would much appreciate.
Suthish NairPosted Mar 7, 2011, 2:59 PM
jimmy shownPosted Mar 7, 2011, 2:57 PM
Suthish NairPosted Mar 7, 2011, 2:42 PM
Suthish NairPosted Mar 5, 2011, 9:56 AM
Welcome to C# Corner.
Re-edit your post again.
Refer examples
Link1, Link2