Comments by NandaNurdin (Top 1 by date)

ok, so here the update

MySqlConnection con = new MySqlConnection(@"data source=localhost;port=3306;userid=root;password=;database=login;");
        MySqlCommand cmd;
        MySqlDataAdapter adapter;

datagridview

public void CekData()
        {
            con.Open();
            adapter = new MySqlDataAdapter("select * from data", con);
            DataTable table = new DataTable();
            adapter.Fill(table);
            dataGridView1.DataSource = table;
            con.Close();
        }

Insert Data

<pre>private void button2_Click(object sender, EventArgs e)
        {
            if (textBox1.Text != "" && textBox2.Text != "" && textBox4.Text != "" && textBox3.Text != "")
            {
                MessageBox.Show("Isi Data Terlebih Dahulu");
            }
            else
            {
                con.Open();
                cmd = new MySqlCommand("INSERT INTO login.data (Nomor,Nama,Alamat,Jenis,Jam) VALUE (@nomor,@nama,@alamat,@jenis,@jam)");
                cmd.Parameters.AddWithValue("@nama",textBox1.Text);
                cmd.Parameters.AddWithValue("@nomor", textBox2.Text);
                cmd.Parameters.AddWithValue("@alamat", textBox4.Text);
                cmd.Parameters.AddWithValue("@jenis", textBox3.Text);
                cmd.Parameters.AddWithValue("@jam", DateTime.Now);
                CekData();

            } con.Close();
        }

Update Data

<pre>private void button3_Click(object sender, EventArgs e)
        {
            if (textBox1.Text != "" && textBox2.Text != "" && textBox4.Text != "" && textBox3.Text != "")
            {
                MessageBox.Show("Isi Data Terlebih Dahulu");
            }
            else
            {
                con.Open();
                cmd = new MySqlCommand("UPDATE login.data SET Nama=@nama, Alamat=@alamat, Jenis=@jenis, Jam=@jam WHERE Nomor=@nomor");
                cmd.Parameters.AddWithValue("@nama",textBox2.Text);
                cmd.Parameters.AddWithValue("@nama", textBox4.Text);
                cmd.Parameters.AddWithValue("@nama", textBox3.Text);
                cmd.Parameters.AddWithValue("@jam", DateTime.Now);
                CekData();
            } con.Close();
        }

now, the problem is, datagridview cannot display because string problem..