C# DATE OF BIRTH HELP

Nur Fasiha

Hi. I am new to C# so please help me on this.

I'm doing a simple program that needs DOB in it. I'm now stuck at the part where I have to retrieve the DOB out from the access database. The coding I need to use to retrieve is DateTime.Day, DateTime.Month and DateTime.Year.

Can someone please help? Any ideas....

Thank you.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh N16y ago
Well!
DataReader is used to retrive the records from any database and MS Access as well in your case...
You could try and let me know for any problems or else you can mark my ans as ACCPETED
Nur Fasiha16y ago
I'm not using DataReader but I'm using Microsoft Access Database.
:)
Santhosh N16y ago
You could do in this way..
string connectionString = "Provider=Microsoft.JET.OLEDB.4.0;data source=C:\\Northwind.mdb";

    OleDbConnection conn = new OleDbConnection(connectionString);

    string sql = "SELECT colList FROM tablename where your cond";

    OleDbCommand cmd = new OleDbCommand(sql, conn);

    conn.Open();

    OleDbDataReader reader;
    reader = cmd.ExecuteReader();

    while (reader.Read())
{
   DateTime dt = Convert.ToDateTime(reader.GetString(0));
int yr = dt.Year;
int mn = dt.Month;
int dy = dt.Day
}
   reader.Close();
    conn.Close();