C#

Member 12082707 wrote:

dear respectabls

Member 12082707 wrote:

i need to retrieve data on click event from same row where dynamic picture is
located...

Member 12082707 wrote:

keep in mind at every click event there may b different number of dynamic
pictures, each have different detail in d.b

Member 12082707 wrote:

ans me as well as soon

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Member 11579490 wrote:

i won't deploy the project i'll only send the files in debug folder.

Vunic wrote:

I just want to filter out the set that goes like 0-10,20-29,40-49

0-9,20-29,40-49

if ((x / 10 & 1) == 0)
    // filtered out
else
    // ignored

var row = grid_lic.CurrentRow;
if (row == null || !row.Selected)
{
    if (grid_lic.SelectedRows.Count == 0)
    {
        MessageBox.Show("Select a row.");
        return;
    }
    
    row = grid_lic.SelectedRows[0];
}

if (string.IsNullOrEmpty(Convert.ToString(row.Cells[1].Value)) 
  || string.IsNullOrEmpty(Convert.ToString(row.Cells[2].Value)) 
  || string.IsNullOrEmpty(Convert.ToString(row.Cells[6].Value)))
{
    MessageBox.Show("Fill the empty cells");
    return;
}

using (OdbcConnection connection = CreateConnection())
using (OdbcCommand command = new OdbcCommand("insert into lojas (NIF, Loja, bloqueado, DataFim, lastupdate, Nome) values (?, ?, ?, ?, ?, ?)", connection))
{
    command.CommandType = CommandType.Text;
    command.Parameters.AddWithValue("@NIF", row.Cells[1].Value);
    command.Parameters.AddWithValue("@Loja", row.Cells[2].Value);
    command.Parameters.AddWithValue("@Bloqueado", checkBox_bloq.Checked);
    command.Parameters.AddWithValue("@DataFim", row.Cells[4].Value);
    command.Parameters.AddWithValue("@lastupdate", row.Cells[5].Value);
    command.Parameters.AddWithValue("@Nome", row.Cells[6].Value);
    
    connection.Open();
    command.ExecuteNonQuery();
}

if(!row.Selected)
 {
   if (grid_lic.SelectedRows.Count == 0)
     {
       MessageBox.Show("Select the row.");
       return;
      }

  row = grid_lic.SelectedRows[0];
  }

 int i = grid_lic.SelectedRows[0].Index;

  if (string.IsNullOrEmpty(Convert.ToString(grid_lic.Rows[i].Cells[1].Value)) || string.IsNullOrEmpty(Convert.ToString(grid_lic.CurrentRow.Cells[2].Value))
|| string.IsNullOrEmpty(Convert.ToString(grid_lic.CurrentRow.Cells[6].Value)))
 {
    MessageBox.Show("Preencha os campos vazios");
    return;
  }

using (OdbcConnection connection = CreateConnection())
{
    OdbcCommand Command = new OdbcCommand("insert into lojas (NIF, Loja, bloqueado, DataFim,       lastupdate, Nome) values (?, ?, ?, ?, ?, ?)", connection);
   Command.CommandType = CommandType.Text;
   Command.Parameters.AddWithValue("@NIF", grid_lic.CurrentRow.Cells[1].Value);
   Command.Parameters.AddWithValue("@Loja", grid_lic.CurrentRow.Cells[2].Value);
   Command.Parameters.AddWithValue("@Bloqueado", checkBox_bloq.Checked);
   Command.Parameters.AddWithValue("@DataFim", grid_lic.CurrentRow.Cells[4].Value);
   Command.Parameters.AddWithValue("@lastupdate", grid_lic.CurrentRow.Cells[5].Value);
   Command.Parameters.AddWithValue("@Nome", grid_lic.CurrentRow.Cells[6].Value);
             
   connection.Open();
   Command.ExecuteNonQuery();
}