Insert and Orace DB

[Naif_Prof]

Hi, i have one one WebForm contain 6 text box and one user control to read date from Javascript code i creat connection to oracle database and i want to insert new record to database every thing(connection to DB) is ok but i have the following prob. * how to write insert statement ( format ) * date conversion in oracle the insert statement is look like insert into emp ( empno,ename,hiredate) values (1234,'Alen',to_date('10-01-2006','dd-mm-yyyy'); how i can write same this statement in code behiend as string and give to dataadepter to execute it any one help me to solve it thanks ..

[V 0]

For SQL syntax, see google or on the Oracle site (need subscribe, but is free). for formatting a Date string See the ToString method of the DateTime object. Good Luck. Coulda, woulda, shoulda doesn't matter if you don't.

[albCode]

Convert date in your application by using ToString method outformatdate .ToString("dd-MM-yyyy"); _____________________ Proud to be Albanian _____________________