How to display a Date-Value from a DataReader in a TextBox

Question

 Date.Text = reader["dateintable"].ToShortDateString();

I want to get the date value from an sql table and display it in a textbox using executereader

Tim Schmelter · Accepted Answer · 2021-03-07 09:29:30Z

1

You can use ToShortDateString if you have a DateTime. But you have just an Object. You need to cast it:

Date.Text = ((DateTime)reader["dateintable"]).ToShortDateString();

Another way is using GetDateTime, but you need the column-index first:

Date.Text = reader.GetDateTime(reader.GetOrdinal("dateintable")).ToShortDateString();

answered Mar 7, 2021 at 9:29

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1