private OleDbType getDBType( Object value )
{
var type = OleDbType.VarChar;
if (value == null)
type = OleDbType.VarChar;
else if (value.GetType() == typeof (DateTime))
type = OleDbType.Date;
else if (value.GetType() == typeof (String))
type = OleDbType.VarChar;
else if (value.GetType() == typeof (Int32))
type = OleDbType.Numeric;
else
type = OleDbType.VarChar;
return type;
}