SqlParameter param = new SqlParameter("@orderDate", SqlDbType.Date);
SqlDbType columnType = myDataTable.Columns["OrderDate"].DataType.SqlDbType;In this example, the SqlDbType property of a DataColumn object is used to retrieve the SqlDbType enumeration value that corresponds to the data type of the column. The SqlDbType enumeration is included in the System.Data.SqlClient namespace, which is part of the .NET Framework.