private void btLG_Click(object sender, EventArgs e) { string strKoneksi = "Data Source=localhost;Initial Catalog=akreditasi;User " + "ID=sa;Password=ayi240799"; SqlConnection koneksi = new SqlConnection(); koneksi.ConnectionString = strKoneksi; koneksi.Open(); SqlDataAdapter sda = new SqlDataAdapter("select count(*) from user_data where userid = '" + boxID.Text + "' and password ='******'", koneksi); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows[0][0].ToString() == "1") { this.Hide(); nama = boxID.Text; userDassboard dsb = new userDassboard(); dsb.Show(); } else { MessageBox.Show("Please enter corect username and password", "alert", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btSG_Click(object sender, EventArgs e) { if (boxPass.Text == boxCnfirm.Text) { string str = ""; string strKoneksi = "Data Source=localhost;Initial Catalog=akreditasi;User " + "ID=sa;Password=ayi240799"; SqlConnection koneksi = new SqlConnection(); koneksi.ConnectionString = strKoneksi; koneksi.Open(); string user = boxID.Text.ToString().Trim(); string pass = boxPass.Text.ToString().Trim(); str = "insert into user_data values (@User, @Pass)"; SqlCommand cmd = new SqlCommand(str, koneksi); cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("User", user)); cmd.Parameters.Add(new SqlParameter("Pass", pass)); cmd.ExecuteNonQuery(); btSG.Enabled = true; userDassboard dsb = new userDassboard(); dsb.Show(); this.Hide(); } else { MessageBox.Show("Please enter corect password", "alert", MessageBoxButtons.OK, MessageBoxIcon.Error); } }