private void button1_Click(object sender, System.EventArgs e) { string login = loginBX.Text; string password = passBX.Text; string MyConString = "SERVER=localhost;" + "DATABASE=baza;" + "UID=root;"; MySqlConnection connection = new MySqlConnection(MyConString); string command = "select ID, posada from pracownicy where login='******' and haslo='" + password + "';"; MySqlDataAdapter da = new MySqlDataAdapter(command, connection); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { if (Convert.ToInt32(dt.Rows[0][1]) == 1) { Serw serw = new Serw(login); serw.Show(); this.Hide(); } else { Admin admin = new Admin(); admin.Show(); this.Hide(); } } }
public RezervasyonListe() { InitializeComponent(); this.FormClosed += new FormClosedEventHandler(Form1_FormClosed); dataGridView1.DataSource = null; dataGridView1.Rows.Clear(); dataGridView1.Refresh(); Admin admin = new Admin(); OleDbDataAdapter dAdapter = admin.RezervasyonListele(); DataTable dataTable = new DataTable(); DataSet ds = new DataSet(); admin.RezervasyonListele().Fill(dataTable); dataGridView1.DataSource = dataTable; dAdapter.Dispose(); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("")) { MessageBox.Show("Lutfen parametrelerinizi kontrol ediniz"); } else { Admin admin = new Admin(); if (admin.RezervasyonSil(textBox1.Text) == 1) { MessageBox.Show("Rezervasyon silindi"); } else { MessageBox.Show("Rezervasyon bulunamadi"); } } }
private void button1_Click(object sender, EventArgs e) { Admin admin = new Admin(); DatabaseManager dbManager = DatabaseManager.dataBaseManager(); dbManager.BookConn = new OleDbConnection(dbManager.getConnParam()); CreateCustomerAdapter(dbManager.BookConn); }
private void Update_Search_FormClosing(object sender, FormClosingEventArgs e) { Admin form = new Admin(); form.Show(); }