System.InvalidOperationException: "Недопустимая попытка чтения при отсутствии данных."

SqlCommand command1 = new SqlCommand("SELECT name1, name2, mame3 FROM Test WHERE id = '" + i + "'", Con1); 
                Con1.Open();
                SqlDataReader reader = command1.ExecuteReader();
                macro[i] = reader.GetString(0);
                nazv[i] = reader.GetString(1);
                nomer[i] = reader.GetString(2);

macro[i] = reader.GetString(0);

public static GenPlan GetByID(int gpID)
{
    GenPlan genPlan = new GenPlan();
    string sqlText = "SELECT ID_EObject, ID_GenPlan, KKS, GPName FROM dbo.tblGenPlan WHERE ID_GenPlan = @gpID";
 
    using (SqlConnection connection = new SqlConnection(_connectionString))
    {
        try
        {
            connection.Open();
 
            SqlCommand sqlCommand = new SqlCommand(sqlText, connection)
            {
                CommandType = CommandType.Text
            };
            SqlParameter param = new SqlParameter
            {
                ParameterName = "@gpID",
                Value = gpID,
                SqlDbType = SqlDbType.Int,
                Direction = ParameterDirection.Input
            };
            sqlCommand.Parameters.Add(param);
 
            using (SqlDataReader dataReader = sqlCommand.ExecuteReader())
            {
                while (dataReader.Read())
                {
                    genPlan.IDEObject = (int)dataReader["ID_EObject"];
                    genPlan.IDGenPlan = (int)dataReader["ID_GenPlan"];
                    genPlan.KKS = dataReader["KKS"] as string ?? "";
                    genPlan.GPName = dataReader["GPName"] as string ?? "";
                }
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
    return genPlan;
}

string connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";"; //Здесь твоя строка подключения
            SqlConnection Con = new SqlConnection(connectionString); 
            SqlCommand command1 = new SqlCommand("SELECT MIN(id) FROM Test", Con", Con1);
            Con.Open();
            int min = (Int32)command.ExecuteScalar();
            SqlCommand com = new SqlCommand("SELECT MAX(id) FROM Test", Con); 
            int max = (Int32)com.ExecuteScalar();
            Con.Close();
            string[] macro = new string[40];
            string[] nazv = new string[40];
            string[] nomer = new string[40];
            for (int i = min; i < max; i++)
            {
                SqlConnection Con1 = new SqlConnection(connectionString);
                SqlCommand command1 = new SqlCommand("SELECT name1, name2, mame3 FROM Test WHERE id = '" + i + "'", Con1);
                Con1.Open(); 
               SqlDataReader reader2 = command1.ExecuteReader()
                
                macro[i] = reader2.GetString(0);
                nazv[i] = reader2.GetString(1);
                nomer[i] = reader2.GetString(2);
                
                Con1.Close();
 
            }

public static List<WorkDrawData> GetWorkDrawDatasBySysID(int idDrawSys)
{
    List<WorkDrawData> workDrawDatas = new List<WorkDrawData>();
    string sqlText =
        "SELECT DrawNum, List, SpecPos, Naimenovanie, Material, TrMont, TrIzg, TrKoeff, PPDiametr, " +
        "TrKoeffIzg, ID_NaryadZakaz, ID_Draw, ID_DrawSys, ID_DrawSpec, Kolvo, KolvoIzg " +
        "FROM dbo.vwPPDrawData " +
        "WHERE ID_DrawSys = @idDrawSys";
 
    using (SqlConnection connection = new SqlConnection(_connectionString))
    {
        try
        {
            connection.Open();
 
            SqlCommand sqlCommand = new SqlCommand(sqlText, connection)
            {
                CommandType = CommandType.Text
            };
            SqlParameter idSys = new SqlParameter
            {
                ParameterName = "@idDrawSys",
                Value = idDrawSys,
                SqlDbType = SqlDbType.Int,
                Direction = ParameterDirection.Input
            };
            sqlCommand.Parameters.Add(idSys);
 
            using (SqlDataReader dataReader = sqlCommand.ExecuteReader())
            {
                while (dataReader.Read())
                {
                    workDrawDatas.Add(new WorkDrawData
                    {
                        DrawNum = dataReader["DrawNum"] as string ?? "",
                        DrawSystem = dataReader["List"] as string ?? "",
                        DrawSpecPos = (int)dataReader["SpecPos"],
                        NameOfSpecPos = dataReader["Naimenovanie"] as string ?? "",
                        Material = dataReader["Material"] as string ?? "",
                        LaborErect = dataReader["TrMont"] == DBNull.Value ? null : (double?)dataReader["TrMont"],
                        LaborAssembly = dataReader["TrIzg"] == DBNull.Value ? null : (double?)dataReader["TrIzg"],
                        ErectCoef = dataReader["TrKoeff"] == DBNull.Value ? null : (double?)dataReader["TrKoeff"],
                        Work = dataReader["PPDiametr"] as string ?? "",
                        AssemblyCoef = dataReader["TrKoeffIzg"] == DBNull.Value ? null : (double?)dataReader["TrKoeffIzg"],
                        IDWorkOrder = dataReader["ID_NaryadZakaz"] == DBNull.Value ? null : (int?)dataReader["ID_NaryadZakaz"],
                        IDDraw = (int)dataReader["ID_Draw"],
                        IDDrawSys = (int)dataReader["ID_DrawSys"],
                        IDDrawSpec = (int)dataReader["ID_DrawSpec"],
                        QtyErect = dataReader["Kolvo"] == DBNull.Value ? null : (double?)dataReader["Kolvo"],
                        QtyAssembly = dataReader["KolvoIzg"] == DBNull.Value ? null : (double?)dataReader["KolvoIzg"]
                    });
                }
            }
            return workDrawDatas;
        }
        catch (Exception ex)
        {
            throw new ApplicationException("Ошибка выборки данных", ex);
        }
    }
}