private void btnlogin_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.Rent_a_carConnectionString))
{
conn.Open();
string cmdstr = String.Format("Select username,password from Users where username ='{0}' and password = '{1}'", txtUser.Text, txtPass.Text);
using (SqlCommand cmd = new SqlCommand(cmdstr, conn))
{
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr["username"].ToString() == txtUser.Text && dr["password"].ToString() == txtPass.Text)
{
try
{
using (Start start = new Start())
{
start.ShowDialog();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
}
conn.Close();
}
}
http://on.wsj.com/H9yjz6 -- India Graduates Millions, but Too Few Are Fit to Hire