private void button1_Click(object sender, EventArgs e)
{
Guncelle2 guncelle2 = new Guncelle2();
guncelle2.label6.Text = label6.Text;
guncelle2.textBox2.Text = label7.Text;
guncelle2.textBox3.Text = label8.Text;
guncelle2.textBox4.Text = label9.Text;
guncelle2.textBox5.Text = label10.Text;
guncelle2.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
Guncelle2 guncelle2 = new Guncelle2();
String sql = String.Empty;
MySqlCommand command = new MySqlCommand();
command.CommandText = "select parola from ogrenci where numara = " + textBox1.Text;
command.Connection = bag;
bag.Open();
try
{
sql = (string)command.ExecuteScalar();
if (textBox2.Text == sql)
{
String sql2 = String.Empty;
MySqlCommand command2 = new MySqlCommand();
command2.CommandText = "select numara from ogrenci where numara = " + textBox1.Text;
command2.Connection = bag;
sql2 = (string)command2.ExecuteScalar();
// guncelle2.label6.Text = sql2;
String sql3 = String.Empty;
MySqlCommand command3 = new MySqlCommand();
command3.CommandText = "select ad from ogrenci where numara = " + textBox1.Text;
command3.Connection = bag;
sql3 = (string)command3.ExecuteScalar();
guncelle2.textBox2.Text = sql3;
String sql4 = String.Empty;
MySqlCommand command4 = new MySqlCommand();
command4.CommandText = "select soyad from ogrenci where numara = " + textBox1.Text;
command4.Connection = bag;
sql4 = (string)command4.ExecuteScalar();
guncelle2.textBox3.Text = sql4;
String sql5 = String.Empty;
MySqlCommand command5 = new MySqlCommand();
command5.CommandText = "select sinif from ogrenci where numara = " + textBox1.Text;
command5.Connection = bag;
sql5 = (string)command5.ExecuteScalar();
guncelle2.textBox4.Text = sql5;
String sql6 = String.Empty;
MySqlCommand command6 = new MySqlCommand();
command6.CommandText = "select parola from ogrenci where numara = " + textBox1.Text;
command6.Connection = bag;
sql6 = (string)command6.ExecuteScalar();
guncelle2.textBox5.Text = sql6;
guncelle2.ShowDialog();
}
else
{
MessageBox.Show("giris basarisiz!!!");
}
}
catch
{
MessageBox.Show("giris basarisiz!!!");
}
bag.Close();
}