btnGiris_Click
MySqlConnection myBaglanti;
string connString;
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
builder.UserID = "root";
builder.Password = "";
builder.Database = "test";
builder.Server = "localhost";
connString = builder.ToString();
myBaglanti = new MySqlConnection(connString);
myBaglanti.Open();
try
{
MySqlCommand komut = new MySqlCommand("select * from uyeler where kullAdi = @txtKulladi and sifre = @txtSifre", myBaglanti);
komut.Parameters.AddWithValue("@kullAdi", txtKulladi.Text);
komut.Parameters.AddWithValue("@sifre", txtSifre.Text);
komut.Connection.Open();
MySqlDataReader rd = komut.ExecuteReader(CommandBehavior.CloseConnection);
if (rd.HasRows)
{
while (rd.Read())
{
if (rd["kullaniciGrubu"].ToString()=="0")
{
MessageBox.Show("admin");
}
else
{
//Boş
}
}
}
else
{
rd.Close();
MessageBox.Show("Kullanici Bilgileri Yalnış");
}
}
catch (Exception)
{
MessageBox.Show("baglanti hatası");
}