private void carregarDados()
{
conexao = new Conexao.Conexao();
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
string connectionString = conexao.getConnectionString();
string query = "SELECT a.Contato,a.Email, a.Data_Nascimento, a.CPF, a.Nome, b.Bairro, b.Cidade, b.Rua, b.CEP, b.Numero, b.Id_Endereco, b.CPF from cliente a\n" +
"\n" + "INNER JOIN endereco b ON b.CPF = a.CPF";
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++)
{
dataGridView1.Rows.Add(dataTable.Rows[i][4], dataTable.Rows[i][3], dataTable.Rows[i][2], dataTable.Rows[i][1], dataTable.Rows[i][0], dataTable.Rows[i][5], dataTable.Rows[i][6], dataTable.Rows[i][7], dataTable.Rows[i][8], dataTable.Rows[i][9], dataTable.Rows[i][10]);
}
}
catch (Exception ex)
{
MessageBox.Show("Erro: " + ex);
}
}
}
}
private void carregarDados()
{
conexao = new Conexao.Conexao();
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
string connectionString = conexao.getConnectionString();
string query = "SELECT a.Nome,a.Preco_Compra, a.Preco_Venda, a.Data_Vencimento, a.Quantidade_estoque, a.Codigo_Barras, b.TipoProduto, a.IdTipo from produto a\n" +
"\n" + "INNER JOIN tipoproduto b ON b.IdTipo = a.IdTipo";
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++)
{
dataGridView1.Rows.Add(dataTable.Rows[i][0], dataTable.Rows[i][1], dataTable.Rows[i][2], dataTable.Rows[i][4], dataTable.Rows[i][5], dataTable.Rows[i][7], dataTable.Rows[i][6], dataTable.Rows[i][3]);
}
}
catch (Exception ex)
{
MessageBox.Show("Erro: " + ex);
}
}
}
}