how can get the date in this format "31-jun-2013"

no problem..anytime

Regards,
Iftikar

hi iftikar 

i have done a mistake in the oracle statement so that why i got this exception again after trying with your suggested code

now its works great with your code !!!!

thanks you so much for timely help Iftikar

can you put the break point and check for what value you have passed for numeric field? 

else 
{
OLCMND4 = new OracleCommand("Select PASSNUMBER,REGISTERINFO,GENDER,TIMEIN,FIRSTNAME,LASTNAME,PHONENUMBER,EMAILID,VEHICLENUMBER,ADDRESSLINE1,ADDRESSLINE2,CITY,PINCODE,COMPANYNAME,PURPOSE,VISITORTYPE,TOMEET,DEPARTMENT,TIMEOUT,VISITORCOUNT,REMARKS,TODAYDATE,CARDNUMBER,PHOTO from VMS_VISITOR where PASSNUMBER ='" + TypeHereTextBox.Text +
                    "'or REGISTERINFO = '" + TypeHereTextBox.Text + "'or GENDER = '" + TypeHereTextBox.Text + "'or TIMEIN = '" + TypeHereTextBox.Text +
                    "'or FIRSTNAME = '" + TypeHereTextBox.Text + "'or LASTNAME = '" + TypeHereTextBox.Text + "'or PHONENUMBER = '" + TypeHereTextBox.Text +
                    "'or EMAILID = '" + TypeHereTextBox.Text + "'or VEHICLENUMBER = '" + TypeHereTextBox.Text + "'or ADDRESSLINE1 = '" + TypeHereTextBox.Text +
                    "'or ADDRESSLINE2 = '" + TypeHereTextBox.Text + "'or CITY = '" + TypeHereTextBox.Text + "' or PINCODE = '" + TypeHereTextBox.Text +
                    "'or COMPANYNAME = '" + TypeHereTextBox.Text + "'or PURPOSE = '" + TypeHereTextBox.Text + "'or VISITORTYPE = '" + TypeHereTextBox.Text +
                    "'or TOMEET = '" + TypeHereTextBox.Text + "'or DEPARTMENT = '" + TypeHereTextBox.Text + "'or TIMEOUT = '" + TypeHereTextBox.Text +
                    "'or VISITORCOUNT = '" + TypeHereTextBox.Text + "'or REMARKS = '" + TypeHereTextBox.Text + "' or CARDNUMBER ='" + TypeHereTextBox.Text + "'", CON);
                   
}

and also share the table column datatype

Regards,
Iftikar

thanks Iftikar 

i tried as per your sugestion but i got the same exception which i have been getting before started asking in this thread

the exception is

ora-01858 a non-numeric character was found where a numeric was expected

you also have seen my code...

can tell me what may be the reason for this exception .. 

with what date value you need to compare for below condition

else if(typeheretextbox.text == date.format [which is what i want])
{

hi iftikar

i have to check

1.if the textbox is empty do this
2.date 
3.other columns

i think if you see my code u will understand
 
con.open();
DTBLE2 = new DataTable();

if (TypeHereTextBox.Text == "") {
 messagebox.shw(empty)
else if(typeheretextbox.text == date.format [which is what i want])
{

OLCMND2 = new OracleCommand("Select PASSNUMBER,REGISTERINFO,GENDER,TIMEIN,FIRSTNAME,LASTNAME,PHONENUMBER,EMAILID,VEHICLENUMBER,ADDRESSLINE1,ADDRESSLINE2,CITY,PINCODE,COMPANYNAME,PURPOSE,VISITORTYPE,TOMEET,DEPARTMENT,TIMEOUT,VISITORCOUNT,REMARKS,to_date(to_char(TODAYDATE, 'DD-MON-YYYY'),'DD-MON-YYYY') AS TODAYDATE,CARDNUMBER,PHOTO from VMS_VISITOR where TODAYDATE = TO_DATE('" + TypeHereTextBox.Text + "','dd-MON-yyyy')", CON);

OADAP1 = new OracleDataAdapter(OLCMND2);

OADAP1.Fill(DTBLE2);

VisitorReportView.DataSource = DTBLE2;


}

else 
{
OLCMND4 = new OracleCommand("Select PASSNUMBER,REGISTERINFO,GENDER,TIMEIN,FIRSTNAME,LASTNAME,PHONENUMBER,EMAILID,VEHICLENUMBER,ADDRESSLINE1,ADDRESSLINE2,CITY,PINCODE,COMPANYNAME,PURPOSE,VISITORTYPE,TOMEET,DEPARTMENT,TIMEOUT,VISITORCOUNT,REMARKS,TODAYDATE,CARDNUMBER,PHOTO from VMS_VISITOR where PASSNUMBER ='" + TypeHereTextBox.Text +
                    "'or REGISTERINFO = '" + TypeHereTextBox.Text + "'or GENDER = '" + TypeHereTextBox.Text + "'or TIMEIN = '" + TypeHereTextBox.Text +
                    "'or FIRSTNAME = '" + TypeHereTextBox.Text + "'or LASTNAME = '" + TypeHereTextBox.Text + "'or PHONENUMBER = '" + TypeHereTextBox.Text +
                    "'or EMAILID = '" + TypeHereTextBox.Text + "'or VEHICLENUMBER = '" + TypeHereTextBox.Text + "'or ADDRESSLINE1 = '" + TypeHereTextBox.Text +
                    "'or ADDRESSLINE2 = '" + TypeHereTextBox.Text + "'or CITY = '" + TypeHereTextBox.Text + "' or PINCODE = '" + TypeHereTextBox.Text +
                    "'or COMPANYNAME = '" + TypeHereTextBox.Text + "'or PURPOSE = '" + TypeHereTextBox.Text + "'or VISITORTYPE = '" + TypeHereTextBox.Text +
                    "'or TOMEET = '" + TypeHereTextBox.Text + "'or DEPARTMENT = '" + TypeHereTextBox.Text + "'or TIMEOUT = '" + TypeHereTextBox.Text +
                    "'or VISITORCOUNT = '" + TypeHereTextBox.Text + "'or REMARKS = '" + TypeHereTextBox.Text + "' or CARDNUMBER ='" + TypeHereTextBox.Text + "'", CON);
                   
}

OADAP2 = new OracleDataAdapter(OLCMND4);
                    OADAP2.Fill(DTBLE2);


                    VisitorReportView.DataSource = DTBLE2;

}

con.close();

in the design what am i doing is.... i am using Autocomplete for every column in the table 
(ie) passnumber,mobilenumber etc

but for date alone i am able to autocomplete the date in textbox if i select any one date it doesn't matches with the oracle date format

for matching both oracle and .net date format i am asking this 

how to check or get the oracle date and convert it to above date format


sorry to ask this big qustn

then don't use any if statement and try like this


Regards,
Iftikar

thanks Iftikar Hussain for your reply

i am searching and getting the data that are matching with the date [above format only]typed in textbox in the above said format in the datagridview 

so i want the format to be like this but it may be past date or today date (ie) user may search for todaydate or any date in the past

so i cant understand this line in your coding

string currentDate = String.Format("{0:dd-MMM-yyyy}", DateTime.Now);

i think you are getting only todaydate and checking it with the textbox data but i want to search for any date in the past

Hi,
        Try like this


Regards,
Iftikar