asp.net C# dislplay date field from access database

[Kurt111780]

Hello,

This should be easy but I can't find the answer anywhere.

Here is my code:

txtAddedDateTime.Text = (string) objRdr["addedDateTime"];

This does not work because the data is stored in an access database as date time data type. I keep getting this error on that line:

System.InvalidCastException: Specified cast is not valid.

How do I modify my code for a date field in access?

Thanks,
Kurt

 

[DaZZleD]

objRdr.GetDateTime(objRdr.GetOrdinal("addedDateTime")).ToString();

you can use any date formatting if you include it in the ToString() function

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage

 

[Kurt111780]

Thanks it works great. Now I have another problem. I have another field that is sometimes empty.

If the date field is empty I get this error again:
System.InvalidCastException: Specified cast is not valid.

I changed my code for that field to look like this:

if (objRdr["completedDateTime"] != null)
{
txtCompletedDateTime.Text = (string) objRdr.GetDateTime(objRdr.GetOrdinal("completedDateTime")).ToString();
}

I still get the same error. Why is it still processing that line if the completedDateTime field is null? is there someting wrong with my if statement?

Thanks,
Kurt

 

[Kurt111780]

It seems an access database date field is not null. How do I check to see if the field contains an actual date if its not null?

any suggestions?

Thanks,
Kurt

 

[Kurt111780]

I found my answer here:

http://www.superdotnet.com/Article.aspx?ArticleID=186

This is the function I found:

public bool IsDate(string sdate) 
{
	DateTime dt;
	bool isDate = true;
	try 
	{
		dt = DateTime.Parse(sdate);  
	}
	catch 
	{
		isDate = false;
	} 
	return isDate;
}