private void button1_Click(object sender, EventArgs e)
{
bool ok = false;
SqlConnection con = new SqlConnection(Form1.constr);
con.Open();
SqlCommand cmd = new SqlCommand("Select email,parola from Utilizatori", con);
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
if (textBox1.Text == dr.GetValue(0).ToString() && textBox2.Text == dr.GetValue(1).ToString())
{
email = dr.GetValue(0).ToString();
ok = true;
MessageBox.Show("Connectarea reusita");
Meniu s = new Meniu();
this.Hide();
s.Show();
}
}
if (!ok)
{
MessageBox.Show("Verifica datele");
}
con.Close();
cmd.Dispose();
}
private void button1_Click(object sender, EventArgs e)
{
//for (int i = 1; i <= 20; i++)
// {
if (textBox4.Text == textBox5.Text && textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "" && textBox5.Text != "")
{
SqlConnection con = new SqlConnection(Form1.constr);
con.Open();
SqlCommand cmd = new SqlCommand("Insert into Utilizatori(email,parola,nume,prenume) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds); mail = textBox1.Text;
MessageBox.Show("Inregistrarea a reusit");
this.Hide();
Meniu s = new Meniu();
s.Show();
}
else
{
MessageBox.Show("Verifica datele");
}
//}
}
