Error: The best overloaded method match for string.ToString has some invalid arguments using C# in ASP.Net

Last Reply 9 months ago By AnandM

Posted 9 months ago

Dear programer,

I have a column named for Deposit_date and isert date from form side is as 01/01/2001

 

But i want to chnage this date as 01-Jan-2001

here is my code that is not working - 

SELECT * FROM Tabel replace(CONVERT(VARCHAR(15), Deposit_date, 106) AS [DD-MMM-YYYY])

 

Results 1 - 5 of 7 12
Posted 9 months ago

Hi AnkitPal,

Can you please explain in more detail exactly what you are trying to achieve?


Posted 9 months ago

i have a column that name is RecordDate and datatype is DATE

when i am insert my record through webform than date is inserted in RecordDate column as below- 

RecordDate 

=========

01/01/2001

01/02/2002

01/03/2003

01/04/2004

 

But I want to do that when i will be insert date through webform than date is insert as belwo form

RecordDate 

===========

1-Jan-2001

1-Feb-2002

1-Mar-2003

1-Apl-2004


Posted 9 months ago

Hi AnkitPal,

if your column RecordDate is having the datatype of DATE then you cant store the date with mentioned format "1-Jan-2001" as it is not supported by the SQL so you can do one thing change the column datatype to VARCHAR and while saving the date convert it into "YourValue".ToString("dd-MMM-yyyy") which will save the date in the "1-Jan-2001" format.


Posted 9 months ago

see below error -date error


Posted 9 months ago

Hi AnkitPal,

can you let me know the value of txtmaturitydate.Text.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html