private void Button_Click_1(object sender, RoutedEventArgs e) { var db = new UserControlLibrary.DBConnection(Constr); if (!db.Connect()) MessageBox.Show("Database Connection Error"); else MessageBox.Show("Database Connected"); }
private string LoadId() { var db = new UserControlLibrary.DBConnection(Constr); string query = string.Format("select Id from info"); db.Connect(); reader=db.Select(query); while (reader.Read()) { int sid = int.Parse(reader[0].ToString()); IdBox.Items.Add(sid); } return "Good"; }
private void Button_Click(object sender, RoutedEventArgs e) { var db = new UserControlLibrary.DBConnection(Constr); int id = int.Parse(IdTextBox.Text); string name = NameTextBox.Text; string query=string.Format("insert into info values('{0}','{1}')", id ,name); string r = db.Insert(query); if (r != "Successfully Inserted") { MessageBox.Show(r, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } else { MessageBox.Show(r); } }