private void SearchButton_Click(object sender, EventArgs e) { SqlConnection sqlConnection = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Ippodrom.mdf;Integrated Security=True"); sqlConnection.Open(); SqlDataAdapter sqlDataAdapter = null; if (HorseFRB.Checked) { sqlDataAdapter = new SqlDataAdapter($"SELECT * FROM HorseView Where Name Like '%{SearchTextBox.Text}%' OR Sex Like '%{SearchTextBox.Text}%' OR Color Like '%{SearchTextBox.Text}%' OR Country Like '%{SearchTextBox.Text}%'", sqlConnection); } if (RiderFRB.Checked) { sqlDataAdapter = new SqlDataAdapter($"SELECT * FROM RiderView Where Name Like '%{SearchTextBox.Text}%' OR Sex Like '%{SearchTextBox.Text}%' OR Country Like '%{SearchTextBox.Text}%'", sqlConnection); } if (LapsFRB.Checked) { sqlDataAdapter = new SqlDataAdapter($"SELECT * FROM LapView Where Name Like '%{SearchTextBox.Text}%' OR Country Like '%{SearchTextBox.Text}%' OR [Horse-winner name] LIKE '%{SearchTextBox.Text}%' OR [Rider-winner name] LIKE '%{SearchTextBox.Text}%'", sqlConnection); } SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter); DataSet dataSetbuf = new DataSet(); sqlDataAdapter.Fill(dataSetbuf); SearchDatagrid.DataSource = dataSetbuf.Tables[0]; SearchDatagrid.Show(); }
private void RefreshMainPanel() { switch (Mode) { case 0: niceLabel1.Text = "Horses"; horseViewDataGridView.Show(); riderViewDataGridView.Hide(); lapViewDataGridView.Hide(); FlowLayoutSearch.Hide(); break; case 1: niceLabel1.Text = "Riders"; horseViewDataGridView.Hide(); riderViewDataGridView.Show(); lapViewDataGridView.Hide(); FlowLayoutSearch.Hide(); break; case 2: niceLabel1.Text = "Laps"; horseViewDataGridView.Hide(); riderViewDataGridView.Hide(); lapViewDataGridView.Show(); FlowLayoutSearch.Hide(); break; case 3: niceLabel1.Text = "Search"; horseViewDataGridView.Hide(); riderViewDataGridView.Hide(); lapViewDataGridView.Hide(); FlowLayoutSearch.Show(); SearchDatagrid.Hide(); break; } }