Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- static string serverName;
- MySqlCommand command;
- public static string connString = @"server=" + serverName + "; Database=database; username=username; password=password";
- // this is the method
- public void fill_grid(string query)
- try
- {
- dataGridView1.DataSource = null;
- MySqlConnection myconn = new MySqlConnection(connString);
- //myconn.Open();
- MySqlCommand mycommand = new MySqlCommand(query, myconn);
- MySqlDataAdapter myAdapter = new MySqlDataAdapter();
- myAdapter.SelectCommand = mycommand;
- DataTable dTable = new DataTable();
- myAdapter.Fill(dTable);
- dataGridView1.DataSource = dTable;
- //myconn.Close();
- }
- catch (MySql.Data.MySqlClient.MySqlException ex)
- {
- MessageBox.Show(ex.Message);
- }
- // this is my button
- private void btnShowInfo_Click(object sender, EventArgs e)
- {
- string query = "select * from students";
- fill_grid(query);
- }
- What am i doing wrong. Thanks!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement