Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void laudos()
- {
- SqlCommand laudo = new SqlCommand("usp_LaudoTecnico", conexaoDADOSADV(true));
- laudo.Parameters.AddWithValue("@NOTAINICIAL", this.txt_notaIni.Text);
- laudo.Parameters.AddWithValue("@NOTAFINAL", this.txt_notaFim.Text);
- laudo.CommandType = CommandType.StoredProcedure;
- laudo.ExecuteNonQuery();
- try
- {
- SqlDataAdapter dados = new SqlDataAdapter(laudo);
- DataTable dtLista = new DataTable();
- dados.Fill(dtLista);
- dgw_laudos.DataSource = dtLista;
- dgw_laudos.Columns["SELECIONAR"].ReadOnly = false;
- dgw_laudos.Columns["NOTA"].ReadOnly = true;
- dgw_laudos.Columns["CLIENTE"].ReadOnly = true;
- dgw_laudos.Columns["COD. PRODUTO"].ReadOnly = true;
- dgw_laudos.Columns["DESCRICAO"].ReadOnly = true;
- dgw_laudos.Columns["LOTE INTERNO"].ReadOnly = true;
- dgw_laudos.Columns["LOTE"].ReadOnly = true;
- dgw_laudos.Columns["NOME QUIMICO"].ReadOnly = true;
- dgw_laudos.Columns["FABRICAÇÃO"].ReadOnly = true;
- dgw_laudos.Columns["VALIDADE"].ReadOnly = true;
- dgw_laudos.Columns["DCB"].ReadOnly = true;
- dgw_laudos.Columns["DCI"].ReadOnly = true;
- dgw_laudos.Columns["CAS"].ReadOnly = true;
- dgw_laudos.Columns["TIPO"].ReadOnly = true;
- dgw_laudos.ColumnHeadersDefaultCellStyle.BackColor = Color.Yellow;
- dgw_laudos.EnableHeadersVisualStyles = false;
- dgw_laudos.Refresh();
- }
- catch (Exception)
- {
- MessageBox.Show("Não existem dados a retornar por favor verifique como o Administrador do sistema");
- return;
- }
- }
Add Comment
Please, Sign In to add comment