private void button1_Click(object sender, EventArgs e)
{
try
{
Con_UsersDB.Close();
Con_UsersDB.Open();
SQLiteDataAdapter SqlDA = new SQLiteDataAdapter();
if (comboBox1.SelectedIndex == 0)
{
SqlDA = new SQLiteDataAdapter("SELECT * FROM Users WHERE Usertype = 'Bruger' ORDER BY Username ASC", Con_UsersDB);
} //if you selected "Bruger" in the usertype drop down menu, then all users with the usertype "Bruger" will be selected and ordered by ascending usernames
if (comboBox1.SelectedIndex == 1)
{
SqlDA = new SQLiteDataAdapter("SELECT * FROM Users WHERE Usertype = 'Superbruger' ORDER BY Username ASC", Con_UsersDB);
}
if (comboBox1.SelectedIndex == 2)
{
SqlDA = new SQLiteDataAdapter("SELECT * FROM Users WHERE Usertype = 'Administrator' ORDER BY Username ASC", Con_UsersDB);
}
DataTable DT = new DataTable();
SqlDA.Fill(DT);
dataGridView1.DataSource = DT;
Con_UsersDB.Close();
}
catch (Exception exc) { MessageBox.Show(exc.Message); }
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Con_fødselsrate_2017.Close();
Con_fødselsrate_2017.Open();
SQLiteDataAdapter SqlDA = new SQLiteDataAdapter();
if (comboBox1.SelectedIndex == 0)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Africa", Con_fødselsrate_2017);
}
if (comboBox1.SelectedIndex == 1)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Asien", Con_fødselsrate_2017);
}
if (comboBox1.SelectedIndex == 2)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Europa", Con_fødselsrate_2017);
}
if (comboBox1.SelectedIndex == 3)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Mellemamerika", Con_fødselsrate_2017);
}
if (comboBox1.SelectedIndex == 4)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Nordamerika", Con_fødselsrate_2017);
}
if (comboBox1.SelectedIndex == 5)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Oceanien", Con_fødselsrate_2017);
}
if (comboBox1.SelectedIndex == 6)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Sydamerika", Con_fødselsrate_2017);
}
DataTable DT = new DataTable();
SqlDA.Fill(DT);
dataGridView1.DataSource = DT;
Con_fødselsrate_2017.Close();
}
catch (Exception exc) { MessageBox.Show(exc.Message); }
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Con.Close(); //closes the connection to the database(for some reason, a non-skippable error occurs when i generate two consecutive errors, and the only fix i could find, is to close the connection before opening it)
Con.Open(); //opens the connection to the database
SQLiteDataAdapter SqlDA = new SQLiteDataAdapter();
if (comboBox1.SelectedIndex == 0)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Africa", Con);
} //if you selected "Africa" in the drop down menu, then all the entries in the "Africa" table will be selected, and ranked by descending birthrates
if (comboBox1.SelectedIndex == 1)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Asien", Con);
}
if (comboBox1.SelectedIndex == 2)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Europa", Con);
}
if (comboBox1.SelectedIndex == 3)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Mellemamerika", Con);
}
if (comboBox1.SelectedIndex == 4)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Nordamerika", Con);
}
if (comboBox1.SelectedIndex == 5)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Oceanien", Con);
}
if (comboBox1.SelectedIndex == 6)
{
SqlDA = new SQLiteDataAdapter("SELECT *, RANK() OVER (ORDER BY Fødselsrate DESC) AS Rang FROM Sydamerika", Con);
}
DataTable DT = new DataTable();
SqlDA.Fill(DT);
dataGridView1.DataSource = DT; //shows the data in the "DT" datatable
Con.Close();
}
catch (Exception exc) { MessageBox.Show(exc.Message); }
}
