oracle forms .net

How to input date from the user and insert the date in the Oracle table in Visual Basic?

I created a table in Oracle with a field for data type date. I've logged in Visual Basic vb.net form to Oracle using OLE DB Provider for Oracle I placed a textbox in a Form. want to input date from the user and insert the date in the Oracle table created by me in Oracle 9i.

Hello – Well, you still have some work to do here in the VB. If you let your users enter a date in the format they want, you'll have problems. For example, tell me what date this is: 02/05/04 It is June 2, 2004? Or is it February 5, 2004? or perhaps in April 2002 5th? If you have a drop down for day, for another month and another for years, so you always know the next dates in Oracle application. are always in the form day / month / year (dd / Mon / yyyy) then it is easier to handle on the database side. You can choose which format suits your user base, both days (Monday, Tuesday …) or day (01, 02, 03 …) and months may be (01, 02) or month may be January, February … and the year may be 08, 09 or 208 2009 … whatsoever. Say you decide go with the format dd / Mon / yyyy which is something like 02/JUN/2008 when you send this to Oracle, Oracle simply say that you are sending a date and send in this format dd / Mon / yyyy then you should use to_date ('02 / Jun/2008 ',' dd / Mon / yyyy ') Basically Oracle to tell you here to take the entry '02 / Jun/2008 "and convert it to a date (to_date) and is passed as' dd / Mon / yyyy '. Hope this helps

Oracle Forms Interactive Workbook $33.75 Excellent Condition Used

Secrets of the Oracle Database $37.32 A guide to the Oracle database server covers such topics as events, fixed tables, SQL statements, PL/SQL packages, application development performance, Oracle NET, and utilities.

Oracle $7.99 Oracle

Oracle, The $9.49 Oracle, The

COURSE ILT:ORACLE 10G FORMS II $150 Brand New

‘Consulting the Village Oracle’ (2009) $467.95 Seeming to tug the viewer into the center of chaos, African geometrical forms and symbols swirl across the canvas. Edward Adeniran explores powers of the oracle, consulted by many West Africans for divination.

Pro ODP .NET for Oracle Database 11g $58.49 No Synopsis Available

BNDL: DATABASE-DRIVEN WEBSITES MICROSOFT .NET & ORACLE $121.22 No Synopsis Available

The Net $4.99 The Net

ODP. NET Developers Guide : Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider For . NET $64.98 No Synopsis Available

*BNDL CK ORACLE 10G ODS FORMS I: BUILD INTERNET APPL $389.99 No Synopsis Available