Tuesday, August 13, 2013

Find Data Types of View Columns

EXEC SP_HELP my_view;
GO

Retrieving a DateTime value from a DataRow (C#)

You can use as follows:

DateTime? myDateField = (row["datefield"] == DBNull.Value) ? null : (DateTime?) DateTime.Parse(row["datefield"].ToString());