public static void SelectAllData()
{
DbList db = new DbList();
string select = "SELECT * FROM weapons.faces";
string connetionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
MySqlConnection conn = new MySqlConnection(connetionString);
conn.Open();
MySqlCommand cmd = new MySqlCommand(select, conn);
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
try
{
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
adapter.Fill(dt);
db.allinfo_dg.ItemsSource = dt.DefaultView;
adapter.Update(dt);
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
conn.Close();
}
private void OpenDatabaseList_Click(object sender, RoutedEventArgs e)
{
DbList l = new DbList();
l.Show();
}