private void Form1_Load(object sender, EventArgs e)
        {
            {

                MySqlConnection baglanti = new MySqlConnection("Server=localhost;Database=dbuser;Uid=root;Pwd='';");
                string komut = "select * from users";
                MySqlDataAdapter da = new MySqlDataAdapter(komut, baglanti);


                DataTable dt = new DataTable();
                da.Fill(dt);
                dataGridView1.DataSource = dt;
            }

            baglanti.Open();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {

                string t1 = textBox1.Text;
                string t2 = textBox2.Text;
                baglanti.Open();
                string ekle = "insert into users(k_adi,k_sifresi) values('" + t1 + "','" + t2 + "')";
                MySqlCommand cmd = new MySqlCommand(ekle, baglanti);
                cmd.ExecuteReader();

            }
            catch (Exception ex)
            {

            }
       
        }

        private void button5_Click(object sender, EventArgs e)
        {

           
        }

        private void button3_Click(object sender, EventArgs e)
        {
            MySqlCommand cmdd = new MySqlCommand("SELECT * from users where ID = '1'", baglanti);
            int Count = Convert.ToInt32(cmdd.ExecuteScalar());

            if (Count != 0)
            {
                MySqlDataReader oku = cmdd.ExecuteReader();
                while (oku.Read())
                {
                    textBox1.Text = oku["k_adi"].ToString();
                    textBox2.Text = oku["k_sifresi"].ToString();

                }
                baglanti.Close();
            }
        }
    }
}