Filling out a form’s textbox with information from a datagridview

Question

I have a datagrideview in a form, and I need that when I click the datagridview cell it fill two fields in another form.

As I show in the image below.

also follows my code

public partial class frmFaturaAnual : Form
{

    SqlConnection conexao = null;
    SqlCommand comando = null;

    public frmFaturaAnual()
    {
        InitializeComponent();
    }

    private void ListaGrid()
    {
        string strSQL = @"SELECT 
                          RTRIM(B1_COD) + ' - ' + B1_DESC AS PRODUTO, 
                          [Janeiro], [Fevereiro], [Março], [Abril], [Maio], [Junho], [Julho], 
                          [Agosto], [Setembro], [Outubro], [Novembro], [Dezembro] 
      FROM ( SELECT SB.B1_COD, SB.B1_DESC, m.nm_mes, SD.D2_QUANT FROM  SD2010 AS SD left outer join mes m on m.cd_mes = month(SD.D2_EMISSAO) 
      INNER JOIN SB1010 AS SB WITH (NOLOCK) ON SB.B1_COD = SD.D2_COD 
      WHERE SD.D_E_L_E_T_ <> '*' 
      AND SD.D2_CF IN ('5102', '5117', '5119', '5123', '5124', '5403', '5405', '6102', '6108', '6110', '6117', '6119', '6123', '6124', '6403', '6405', '7102') 
      AND YEAR(SD.D2_EMISSAO) = '" + txtAno.Text +"' ) AS F PIVOT (SUM(D2_QUANT) FOR nm_mes IN  ([Janeiro], [Fevereiro], [Março], [Abril], [Maio], [Junho], [Julho], [Agosto], [Setembro], [Outubro], [Novembro], [Dezembro])) AS P";

        conexao = new SqlConnection(conm);
        comando = new SqlCommand(strSQL, conexao);

        try
        {
            SqlDataAdapter dados = new SqlDataAdapter(comando);
            DataTable dtLista = new DataTable();
            dados.Fill(dtLista);

            dgAnual.DataSource = dtLista;
        }
        catch
        {
            MessageBox.Show("Não existem dados a serem encontrados");
        }
    }

    private void btnPesquisar_Click(object sender, EventArgs e)
    {
        ListaGrid();
    }

    private void btnFechar_Click(object sender, EventArgs e)
    {
        Close();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        frmImpFatAnual imp = new frmImpFatAnual(txtAno.Text);
        imp.Show();
    }

    private void dgAnual_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
    { 

        frmQtdaCliente custo = new frmQtdaCliente(txtAno.Text);
        custo.Show();
    }
}

Answer 1

Whereas, you will use the Doubleclick event in datagridview, and that will always open a new form, when the event occurs:

in your frmQtdaCliente, create two properties

public string Mes {get;set;}
public string Produto {get;set;}

in the form load event, fill in the textbox.

to call the form, in the event dgAnual_CellDoubleClick:

frmQtdaCliente custo = new frmQtdaCliente(txtAno.Text);
custo.Mes= dgAnual.Rows[e.RowIndex].Cell["nome da sua coluna mes"].Value.ToString();
custo.Produto = dgAnual.Rows[e.RowIndex].Cell["nome da sua coluna produto"].Value.ToString();

cost. Show();

Answer 2

There are several ways to do this. I almost always opt for the idea of sending the data via constructor to the new form, this makes it easy to put values in the controls right after they are created and also prevents these controls from being accessed outside the form.

My tip is basically based on three things to do

1. Add an event from click (or double click) in the DataGridView (not in cells - because the event is fired anywhere on the line that is clicked, if you do not want this use the event CellDoubleClick even);

2. Capture the necessary information;

3. Pass this information as a parameter in the new constructor form.

Example:

private void dgAnual_DoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{ 
    if(e.RowIndex < 0 || e.ColumnIndex < 0)
        return;

    var row = dgAnual.Rows[e.RowIndex];
    var nomeProduto = row["NomeDaColunaProduto"].Value;
    var mes = row["NomeDaColunaMes"].Value;

    FormNovo form = new FormNovo(nomeProduto, mes);
    form.Show();
}