private void GetColumnInfo()
{
    System.Collections.Generic.Dictionary<string, int> columnLengthList;
    SqlConnection SqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["OccasionsReadWrite"].ConnectionString);
    SqlConn.Open();
    string cmd = "SELECT TOP 1 * FROM tblOccasions ORDER BY OccasionID DESC";
    SqlDataAdapter adapter = new SqlDataAdapter(cmd, SqlConn);
    DataTable dt = new DataTable();
    adapter.FillSchema(dt, SchemaType.Mapped);
    adapter.Fill(dt);
 
    columnLengthList = new System.Collections.Generic.Dictionary<string, int>();
    foreach (DataColumn col in dt.Columns)
        columnLengthList.Add(col.ColumnName, MaxLength(col.MaxLength, col.DataType);
 
    SqlConn.Close();
}
 
private int MaxLength(int maxLength, Type dataType)
{
    if (maxLength > 0)
        return maxLength;
    else
    {
        int n = 0;
        switch (dataType.ToString().ToLower())
        {
            case "system.datetime":
                break;
            case "system.int32":
                break;
            case "system.string":
                break;
            default:
                break;
        }
        return n;
    }
}