Reading a date using DataReader

c# .net ado.net datareader
TeaDrinkingGeek picture TeaDrinkingGeek · Apr 11, 2011 · Viewed 109k times · Source

I read a string using this format with a data reader. How can I read in a date using similar format?

while (MyReader.Read())
{
    TextBox1.Text = (string)MyReader["Note"];
}

Answer

Sukhjeevan picture Sukhjeevan · Apr 11, 2011

Try as given below:

while (MyReader.Read())
{
    TextBox1.Text = Convert.ToDateTime(MyReader["DateField"]).ToString("dd/MM/yyyy");
}

in ToString() method you can change data format as per your requirement.

Related questions

Enforce only single row returned from DataReader

I seem to write this quite a lot in my code: using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { result = new User((int)reader["UserId"], reader["UserName"].ToString()); } if (reader.Read()) { throw new DataException("multiple rows returned from query"); } } Is …

Read More
MetadataException: Unable to load the specified metadata resource

All of a sudden I keep getting a MetadataException on instantiating my generated ObjectContext class. The connection string in App.Config looks correct - hasn't changed since last it worked - and I've tried regenerating a new model (edmx-file) from …

Read More
Populate data table from data reader

I'm doing a basic thing in C# (MS VS2008) and have a question more about proper design than specific code. I am creating a datatable and then trying to load the datatable from a datareader (which is based on an …

Read More