Advertisement
dantepw

Untitled

Oct 22nd, 2014
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.77 KB | None | 0 0
  1.         public void popularTabela(String adapter, String nomeTabela)
  2.         {
  3.             MySqlConnection cn = new MySqlConnection("server=localhost;uid=root;pwd=faat;database=vendas");
  4.             cn.Open();
  5.  
  6.             try
  7.             {
  8.                 DataSet mDataSet = new DataSet();
  9.  
  10.                 MySqlDataAdapter mAdapter = new MySqlDataAdapter(adapter, cn);
  11.                 mAdapter.Fill(mDataSet, nomeTabela);
  12.  
  13.                 dataGridViewClientes.DataSource = mDataSet;
  14.                 dataGridViewClientes.DataMember = nomeTabela;
  15.             }
  16.             catch (Exception ex)
  17.             {
  18.                 MessageBox.Show(ex.Message, "Erro!!");
  19.             }
  20.             finally
  21.             {
  22.                 cn.Close();
  23.             }
  24.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement