Reading a date using DataReader

by

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.

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. MetadataException: Unable to load the specified metadata resource
  3. Get output parameter value in ADO.NET
  4. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  5. SQLite Database Locked exception
  6. Is it necessary to manually close and dispose of SqlDataReader?
  7. Populate data table from data reader
  8. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  9. Difference with Parameters.Add and Parameters.AddWithValue
  10. SqlConnection SqlCommand SqlDataReader IDisposable
  11. Exception when AddWithValue parameter is NULL
  12. Calling Oracle stored procedure from C#?
  13. Insert into C# with SQLCommand
  14. MultipleActiveResultSets=True or multiple connections?
  15. How to pass a table-value parameter
  16. How to fill Dataset with multiple tables?
  17. How DataReader works?
  18. How to keep single SQL Server connection instance open for multiple request in C#?
  19. DataTable equivalent in Java [duplicate]
  20. How do I re-write a SQL query as a parameterized query?
  21. Multiples Table in DataReader
  22. Check if a SQL table exists
  23. What is the difference between dataview and datatable?
  24. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  25. How do I connect to a SQL database from C#?
  26. .net connection pooling
  27. Do we have transactions in MS-Access?
  28. Random Gaussian Variables
  29. File.Delete failing when Image.FromFile was called prior it, despite making copy of loaded image and destroying original one
  30. .NET Core include folder in publish

Leave a Comment