DateTime Difference

In the column "Time," in the table, it stores the current time or todays time?

Can u please tell  time of which date is stored in the "Time" Column in the table.

The time is stored which the user wants to store say 09:00:00 am.

The time is stored to record based on the user request by say admin. its not the current date or today's time, the time of a particular day as to be updated

Okay, As for as i  understand i can give u some logic.

  - Convert Char to time in sql. ()i.e your time field and store that in temp variable.

  - In the datetime field, u can seperate the time from the datetime and store that in another varible

 - Compare both the time is the result.

Converting Char to time and seperating the time from date time is stright forward and u can search for the code.

Please let me know if this is not clear.

Logic is correct I think,please give code as an example please

Ok Gokuldas you can try this

 DateTime ObjLocDate1 = new DateTime();
        DateTime ObjLocDate2 = new DateTime();
        string StrLocTime = string.Empty;
        ObjLocDate1 = Convert.ToDateTime(txtDate1.Text);
        ObjLocDate2 = Convert.ToDateTime(txtDate2.Text);
        StrLocTime = string.Format("{0}:{1}:{2}", ObjLocDate1.Subtract(ObjLocDate2).Hours.ToString(), ObjLocDate1.Subtract(ObjLocDate2).Minutes.ToString(), ObjLocDate1.Subtract(ObjLocDate2).Seconds.ToString());
        lblDate.Text = StrLocTime;

In this example i have simply passed the hard code values to the  textbox.

But in you case you will have to fetch the time from you table