0
Reply

Convert int to datetime

Sandhya Bhosale

Sandhya Bhosale

Oct 31 2006 2:13 AM
2.1k
I have an insert procedure wherein a user can enter max limit in the form of interger.

But during submit button, the integer value has to be converted to datetime.

I have written it as:

cmd.Parameters.Add("@Max_Limit", System.Convert.ToDateTime(txtMaxLimit.Value).ToShortDateString);

It gives me the following errors:

Error 2 The best overloaded method match for 'System.Data.SqlClient.SqlParameterCollection.Add(string, object)' has some invalid arguments

Error 3 Argument '2': cannot convert from 'method group' to 'object'

Please help.......................