private void button1_Click(object sender, EventArgs e)
{
int count = 0;
string connectionString = "Data Source=.;Initial Catalog=MyAppointmentDb;Integrated Security=True;Pooling=False";
string query = "Insert Into [Login] Values('" + tbxUName.Text + "', '" + tbxPword2.Text + "')";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
if (tbxPword2.Text == tbxConPword.Text)
{
count += cmd.ExecuteNonQuery();
conn.Close();
}
else
{
MessageBox.Show("Password and Confirm Password do not match");
}
if (count == 1)
{
ClientDetails clientDetails = new ClientDetails();
clientDetails.Show();
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
int count = 0;
string connectionString = "Data Source=.;Initial Catalog=MyAppointmentDb;Integrated Security=True;Pooling=False";
string query = "Select * From [Login] Where UserName = '******' And [Password] = '" + tbxPword.Text + "'";
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter(query, conn);
DataTable dt = new DataTable();
try
{
count += da.Fill(dt);
if (count == 1)
{
ClientDetails clientDetails = new ClientDetails();
clientDetails.Show();
this.Hide();
}
else
{
MessageBox.Show("Invalid Credentials");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}