Date convert problem

Hi,

Your problem is solved ? Then accept the answer it will help for others...

DateTime dt = DateTime.Now;

string format = "dd-mm-yyyy";

string dtTObeInsertedInSQL = dt.ToString(format);

now save this "dtTObeInsertedInSQL " in database

Hi,

Your database value contain date with time so before searching the report you can use the same format for date and trim the time like below example..

Textbox.text = dd/mm/yyyy;

Datbasevalue = dd/mm/yyyy;//use sql convert method to trim the date

if (dd/mm/yyyy == dd/mm/yyyy)

{

//code

}

Please Example

Get it as string from database and do formating in c# and bind it.