C#

public static IEnumerable<KeyValuePair<T1, List<T1>>> ToChunkedKvPList<T1>(this IEnumerable<T1> source, int chunksz)
{
    if (source == null) throw new ArgumentNullException("source");
    if (chunksz <= 0) throw new ArgumentOutOfRangeException("chunksz", "The chunk size must be greater than 0.");
    
    // The iterator method should be separate from the argument validation,
    // so that the exceptions are throw when the method is called,
    // rather than when the returned sequence is iterated.
    
    return ToChunkedKvPListIterator(source, chunksz);
}

private static IEnumerable<KeyValuePair<T1, List<T1>>> ToChunkedKvPListIterator<T1>(IEnumerable<T1> source, int chunksz)
{
    int currentChunkSize = 0;
    T1 currentHeader = default(T1);
    var currentChunk = new List<T1>(chunksz);
    
    foreach (T1 item in source)
    {
        if (currentChunkSize == 0)
        {
            currentHeader = item;
        }
        else
        {
            currentChunk.Add(item);
        }
        
        currentChunkSize++;
        
        if (currentChunkSize == chunksz)
        {
            yield return new KeyValuePair<T1, List<T1>>(currentHeader, currentChunk);
            
            currentChunkSize = 0;
            currentHeader = default(T1);
            currentChunk = new List<T1>(chunksz);
        }
    }
    
    if (currentChunkSize != 0)
    {
        // We have a partial chunk left over:
        yield return new KeyValuePair<T1, List<T1>>(currentHeader, currentChunk);
    }
}

IEnumerable<int> AskDeepThought()
{
    while (true)
    {
        yield return 42;
    }
}

var answers = AskDeepThought().ToChunkedKvPList().Take(42);
// If ToChunkedKvPList uses Count(), this will never return.

BillWoodruff wrote:

pending eye-surgery

BillWoodruff wrote:

modified closures

BillWoodruff wrote:

an IEnumerable that was not "sequence deterministic"

using (var bc = new BlockingCollection<int>())
{
    Task.Run(() =>
    {
        for (int i = 0; i < 10; i++)
        {
            bc.Add(i);
            Thread.Sleep(100);
        }
        
        bc.CompleteAdding();
    });
    
    var list = bc.GetConsumingEnumerable();
    Console.WriteLine("{0} items in the collection.", list.Count());
    // Output: 10 items in the collection.
    
    Console.WriteLine("Iterate the list:");
    foreach (var item in list)
    {
        Console.WriteLine(item);
    }
    // No output.
    
    Console.WriteLine("Iterate again:");
    foreach (var item in bc.GetConsumingEnumerable())
    {
        Console.WriteLine(item);
    }
    // Still no output.
}

BillWoodruff wrote:

have you ever thought about writing articles, or tip/tricks, for CP on Linq ?

Richard Deeming wrote:

It's not technically wrong, and the code will work as expected, but it "feels" icky. (Hence your post asking if there was a way to avoid it.)

return source
    .Select((item, index) => new 
    { 
        item, 
        chunk = index / chunksz 
    })
    .GroupBy(
        x => x.chunk, 
        x => x.item,
        (key, grp) => KeyValuePair.Create(grp.First(), grp.Skip(1).ToList())
    );

private void bt_gravar_Click(object sender, EventArgs e)
        {
            
         Gravar();          
           
        }

 private void bt_preencher_Click(object sender, EventArgs e)
        {
         Gravar();      
            
        }

public void Gravar()
{
BD_Conexao();
if (grid_lic.CurrentRow.Cells[3].Value.ToString() != "" | grid_lic.CurrentRow.Cells[3].Value.ToString() == "True")

   bloqueador = 1;
else
   bloqueador = 0;

   
if (grid_lic.CurrentRow.Cells[7].Value.ToString() != "" | grid_lic.CurrentRow.Cells[7].Value.ToString() == "True")
   EArtigo = 1;
else
   EArtigo = 0;

string Cmd = "Select * from lojas where NIF ='" + grid_lic.CurrentRow.Cells[1].Value + "' and loja ='" + grid_lic.CurrentRow.Cells[2].Value + "'";

 OdbcCommand cm2 = new OdbcCommand(Cmd, con);
 OdbcDataReader dr = cm2.ExecuteReader();

string cmd = "insert into licenciamentoloja (bloqueador, EArtigo) values (?, ?)";

OdbcCommand cm = new OdbcCommand(cmd, con);

cm.Parameters.AddWithValue("@bloqueador", bloqueador);
cm.Parameters.AddWithValue("@EArtigo", EArtigo);

cm.ExecuteNonQuery();

Consulta()

}

public void Consulta()
{
          
 con = new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=xxx; database=licenciamento; uid=estagio; password=1234; option = 3 ");
            
con.Open();

OdbcCommand Command = con.CreateCommand();
 Command.CommandText = "select licenciamentoloja.bloqueador, licenciamentoloja.Artigo from licenciamentoloja;" 

Command.CommandType = CommandType.Text;
Command.Connection = con;

OdbcDataAdapter adapter = new OdbcDataAdapter();
adapter.SelectCommand = Command;
_ds = new DataSet();
 dt = _ds.Tables["filtro"];
 adapter.Fill(_ds, "filtro");
 grid_lic.DataSource = _ds;
 grid_lic.DataMember = _ds.Tables[0].TableName;
 grid_lic.DataMember = "filtro";
}

  public void BD_Conexao()
  {
  try
     {
      OdbcConnection con = new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=xxx; database=licenciamento; uid=estagio; password=1234; option = 3 ");
      
      con.Open();
     }

  catch (Exception ex)
  {
   Console.WriteLine("Erro na ligação à base de dados. \n{0}", ex.Message);

    return;
  }

    }

Member 11449447 wrote:

It just confirms that it is not filling the checkboxes correctly, not why this should be happening.

Member 11449447 wrote:

string Cmd = "Select * from lojas where NIF ='" + grid_lic.CurrentRow.Cells[1].Value + "' and loja ='" + grid_lic.CurrentRow.Cells[2].Value + "'";
 
OdbcCommand cm2 = new OdbcCommand(Cmd, con);
OdbcDataReader dr = cm2.ExecuteReader();

using (OdbcConnection con = new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=xxx; database=licenciamento; uid=estagio; password=1234; option = 3 "))
{
    con.Open();
    
    using (OdbcCommand cm2 = new OdbcCommand("Select * from lojas where NIF = ? and loja = ?", con))
    {
        cm2.Parameters.AddWithValue("NIF", grid_lic.CurrentRow.Cells[1].Value);
        cm2.Parameters.AddWithValue("loja", grid_lic.CurrentRow.Cells[2].Value);
        
        using (OdbcDataReader dr = cm2.ExecuteReader())
        {
            // TODO: Read the results and do something with them...
        }
    }

    using (OdbcCommand cm = new OdbcCommand("insert into licenciamentoloja (bloqueador, EArtigo) values (?, ?)", con))
    {
        cm.Parameters.AddWithValue("@bloqueador", bloqueador);
        cm.Parameters.AddWithValue("@EArtigo", EArtigo);
        cm.ExecuteNonQuery();
    }
}

Member 11449447 wrote:

if (grid_lic.CurrentRow.Cells[3].Value.ToString() != "" | grid_lic.CurrentRow.Cells[3].Value.ToString() == "True")

if (grid_lic.CurrentRow.Cells[3].Value.ToString() != "" || grid_lic.CurrentRow.Cells[3].Value.ToString() == "True")

if (grid_lic.CurrentRow.Cells[3].Value.ToString() != "")

Member 11449447 wrote:

public void BD_Conexao()

public OdbcConnection BD_Conexao()
{
    var result = new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=xxx; database=licenciamento; uid=estagio; password=1234; option = 3 ");
    result.Open();
    return result;
}

using (OdbcConnection con = BD_Conexao())
{
    ...
}

if (grid_lic.CurrentRow.Cells[3].Value.ToString() != "" || grid_lic.CurrentRow.Cells[3].Value.ToString() == "True")
   bloqueador = 1;
else
   bloqueador = 0;

if(grid_lic.CurrentRow.Cells[3].Value.ToString() == "True")
   bloqueador = 1;
else
   bloqueador = 0;

if(grid_lic.CurrentRow.Cells[3].Value.ToString() == "False" ||grid_lic.CurrentRow.Cells[3].Value.ToString() == "" )
   bloqueador = 0;
else
   bloqueador = 1;