Guest User

Untitled

a guest
Jul 20th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.73 KB | None | 0 0
  1. private void laudos()
  2. {
  3. SqlCommand laudo = new SqlCommand("usp_LaudoTecnico", conexaoDADOSADV(true));
  4. laudo.Parameters.AddWithValue("@NOTAINICIAL", this.txt_notaIni.Text);
  5. laudo.Parameters.AddWithValue("@NOTAFINAL", this.txt_notaFim.Text);
  6. laudo.CommandType = CommandType.StoredProcedure;
  7. laudo.ExecuteNonQuery();
  8.  
  9. try
  10. {
  11. SqlDataAdapter dados = new SqlDataAdapter(laudo);
  12. DataTable dtLista = new DataTable();
  13. dados.Fill(dtLista);
  14.  
  15. dgw_laudos.DataSource = dtLista;
  16. dgw_laudos.Columns["SELECIONAR"].ReadOnly = false;
  17. dgw_laudos.Columns["NOTA"].ReadOnly = true;
  18. dgw_laudos.Columns["CLIENTE"].ReadOnly = true;
  19. dgw_laudos.Columns["COD. PRODUTO"].ReadOnly = true;
  20. dgw_laudos.Columns["DESCRICAO"].ReadOnly = true;
  21. dgw_laudos.Columns["LOTE INTERNO"].ReadOnly = true;
  22. dgw_laudos.Columns["LOTE"].ReadOnly = true;
  23. dgw_laudos.Columns["NOME QUIMICO"].ReadOnly = true;
  24. dgw_laudos.Columns["FABRICAÇÃO"].ReadOnly = true;
  25. dgw_laudos.Columns["VALIDADE"].ReadOnly = true;
  26. dgw_laudos.Columns["DCB"].ReadOnly = true;
  27. dgw_laudos.Columns["DCI"].ReadOnly = true;
  28. dgw_laudos.Columns["CAS"].ReadOnly = true;
  29. dgw_laudos.Columns["TIPO"].ReadOnly = true;
  30.  
  31.  
  32. dgw_laudos.ColumnHeadersDefaultCellStyle.BackColor = Color.Yellow;
  33. dgw_laudos.EnableHeadersVisualStyles = false;
  34. dgw_laudos.Refresh();
  35. }
  36. catch (Exception)
  37. {
  38. MessageBox.Show("Não existem dados a retornar por favor verifique como o Administrador do sistema");
  39. return;
  40. }
  41. }
Add Comment
Please, Sign In to add comment