i need to update a column entire table

Try:

UPDATE MyTable SET MyColumn=MyValue

If you don't specify a WHERE clause, all rows are updated.

Update Tablename set [date]=getdate()

Please try to do some work from your side and ask questions with code issues you have. An open question like the above is not recommended. A simple Google Search for SQL Update will fetch lot of results and with that you could have started.

Please refer below for some reference .

http://www.w3schools.com/sql/sql_update.asp[^]


https://www.google.co.in/?gws_rd=ssl#q=SQL+update+column[^]

To update the entire column, in the table just execute this SqlCommand on your database server.

"UPDATE table_name SET column_name = value"

Since there is no WHERE clause, this would update the column in the entire table. For more on databases in C#, read this article How to connect SQL Database to your C# program, beginner's tutorial[^]