How can i do when i insert date to sqlserver it also error?

[sixfeetsix]

try to format it this way before putting the date in your sql statement :

DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")

should work whatever regional settings you have.