private void SearchInDB(object sender, RoutedEventArgs e) { string SQLQuery = "SELECT * FROM `literature` WHERE "; string connStr = @"Database = listofsources; Data Source = localhost; User Id = root; Password ="******"") { SQLQuery += "`" + win.TableGrid.Columns[i].Header + "` = " + "'" + tb.Text + "' AND "; } } SQLQuery += "replaceme"; SQLQuery = SQLQuery.Replace("AND replaceme", ""); MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connStr); if (result.HasError == false) { win.TableGrid.ItemsSource = result.ResultData.DefaultView; win.Activate(); Close(); } else { MessageBox.Show(result.ErrorText); } }
private void From_DB(object sender, RoutedEventArgs e) { string SQLQuery = "SELECT * FROM literature"; MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connStr); if (result.HasError == false) { SourcesTable win = new SourcesTable(); win.Show(); win.Owner = this; win.TableGrid.ItemsSource = result.ResultData.DefaultView; win.TableGrid.Columns[6].Width = 183; } else { MessageBox.Show("Что-то не так с базой данных", "", MessageBoxButton.OK, MessageBoxImage.Error); } }