Updating Datetime field in sql server database

[Sunil Tripathi]

I am working C#.net. I have a datetime variable 'currDate' whose value is set to current date. when i fire an update query as

Update UserLogin set Date=currDate where UserId='"+txtUserName.text+"';

i get an error 'cannot update column currDate '.how should i go about it.

[ck9663]

Are you updating a variable or a column? Are Date and currDate both a column? If one them is a variable, you have mto adjust your syntax.

Happy Coding!!!


~~ CK