how to use the TO_DATE Function for more date inputs.

Question

i have writing a query to connect oracle db with asp.net, and i have created a webpage and then i kept 3 textboxes, and two buttons for getting input and o/p, in textboxes i have to give the date and in oracle db i have created column for those dates, am using to_date function, but i dont know how to write the to_date for continuesly, its says some syntax error. so can you please tell me how to use the to_date function for continuesly and next to some uppended textboxes, i ll mention the code below for ur reference.

string oocdate = txtoocaccpteddate.Text;
string filingdate = txtfillingdate.Text;
string fieldautorities = txtfieldwithauth.Text;
string receipt = txtreceiptdate.Text;
string approved = txtapproveddate.Text;
string appvalidfrom = txtapplicationvalidfrom.Text;
string appvalidto = txtapplicationvalidto.Text;

string sql = "insert into tmp (REC_KEY, APPL_NO, EMP_NO, CASE_VISA_TYPE_CODE, CASE_VISA_SUBTYPE_CODE, OOC_ACCEPTED_DATE, FILING_SENT_DATE, FILED_WITH_AUTHORITIES, RECEIPT_DATE, APPROVED_DATE, APPL_VALID_FROM, APPL_VALID_TO) values ('" + txtreckey.Text + "','" + txtrefappno.Text + "','" + txtempid.Text + "','" + txtcasevisatype.Text + "','" + txtcasevisatypecode.Text + "','(TO_DATE('" + oocdate + "','DD-MM-YY HH:MI A.M.'))','(TO_DATE('" + filingdate + "','DD-MM-YY HH:MI A.M.'))','(TO_DATE('" + fieldautorities + "','DD-MM-YY HH:MI A.M.'))','" + txtreceiptno.Text + "','(TO_DATE('" + receipt + "','DD-MM-YY HH:MI A.M.'))','(TO_DATE('" + approved + "','DD-MM-YY HH:MI A.M.'))','(TO_DATE('" + appvalidfrom + "','DD-MM-YY HH:MI A.M.'))','(TO_DATE('" + appvalidto + "','DD-MM-YY HH:MI A.M.'))";

// here i have diclared the textboxes as some var name and i have appending them in to_date functions. here first two columns are varchar type, like rec_key and emp id, case visa type, case visa subtype, these things are varchar and other than this everything is date. i dont knnow the syntax for continuesly using to_date function.

Iftikar Hussain · Answer

you like to append two textbox data and insert into datecolumn? Regards Iftikar

Iftikar Hussain · Answer

Hi Try like this string sql = insert into tmp (REC_KEY APPL_NO EMP_NO CASE_VISA_TYPE_CODE CASE_VISA_SUBTYPE_CODE OOC_ACCEPTED_DATE FILING_SENT_DATE FILED_WITH_AUTHORITIES RECEIPT_DATE APPROVED_DATE APPL_VALID_FROM APPL_VALID_TO) values (' + txtreckey.Text + '' + txtrefappno.Text + '' + txtempid.Text + '' + txtcasevisatype.Text + '' + txtcasevisatypecode.Text + ''TO_DATE(' + oocdate + ''DD-MM-YY HH:MI A.M.')''TO_DATE(' + filingdate + ''DD-MM-YY HH:MI A.M.')''TO_DATE(' + fieldautorities + ''DD-MM-YY HH:MI A.M.')'' + txtreceiptno.Text + ''TO_DATE(' + receipt + ''DD-MM-YY HH:MI A.M.')''TO_DATE(' + approved + ''DD-MM-YY HH:MI A.M.')''TO_DATE(' + appvalidfrom + ''DD-MM-YY HH:MI A.M.')''TO_DATE(' + appvalidto + ''DD-MM-YY HH:MI A.M.')); if you are not passing time then use TO_DATE(' + oocdate + ''DD-MM-YY') Regards Iftikar

Rajesh B · Answer

actually i wants to 30 columns in a table in that i have around date columns and above 20 varchar and number columns in oracle db for that am using like above coding  i can fetch the data(select) into textboxes and i needs edit the selected data and again i have to insert the new data entered into db.for that am using this to_date function i dont know the sysntax to write for the to_date function in asp.net c# query for inserting continuesly 2 date columns and after varchar textbox appended column TO_date function

Rajesh B · Answer

hi Iftikar Hussain thanks for your answer but my doubt is how to use that to_date functions for continuelsy two textboxes and appended textboxes syntax for exampleinsert into tmp(rec_keyempnoapproved date) values('+txtreckey.Text+''+emp id.text+'(to_date('+approveddate.Text+''DD-mm-yy)''(to_date(someother date column)); is this right or something other format is there?