private void carregarDados()
{
conexao = new Utils.Conexao();
CadastroTabela.DataSource = null;
CadastroTabela.Rows.Clear();
CadastroTabela.Refresh();
string connectionString = conexao.getConnectionString();
string query = "SELECT Nome, Codigo_Barras, Fornecedor, Preco_Compra, Preco_Venda, Quantidade_Estoque, Data_Vencimento from produto";
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
using (MySqlDataAdapter adapter = new MySqlDataAdapter(query, conn))
{
try
{
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
CadastroTabela.Rows.Add(dataTable.Rows[i][0], dataTable.Rows[i][1], dataTable.Rows[i][2], dataTable.Rows[i][3], dataTable.Rows[i][4], dataTable.Rows[i][5], dataTable.Rows[i][6]);
}
}
catch (Exception ex)
{
MessageBox.Show("Erro: " + ex);
}
}
}
}
private void carregarDados()
{
conexao = new Utils.Conexao();
CadastroTabela.DataSource = null;
CadastroTabela.Rows.Clear();
CadastroTabela.Refresh();
string connectionString = conexao.getConnectionString();
string query = "SELECT Nome, Registro, Data_Nascimento, Email, Contato from Entidade";
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
using (MySqlDataAdapter adapter = new MySqlDataAdapter(query, conn))
{
try
{
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
CadastroTabela.Rows.Add(dataTable.Rows[i][0], dataTable.Rows[i][1], dataTable.Rows[i][2], dataTable.Rows[i][3], dataTable.Rows[i][4]);
}
}
catch (Exception ex)
{
MessageBox.Show("Erro: " + ex);
}
}
}
}
