private void metroButton2_Click_1(object sender, EventArgs e)
{
Studentinfo ss = new Studentinfo(id);
ss.Show();
this.Hide();
}
private void metroButton1_Click(object sender, EventArgs e)
{
OleDbDataAdapter adap = new OleDbDataAdapter("select * from Student where StdId = " + metroTextBox1.Text + " and Password = "******" ", con);
adap.Fill(d2, "Student");
Studentinfo si = new Studentinfo(metroTextBox1.Text);
si.Show();
this.Hide();
//Studentinfo s = new Studentinfo();
//try
//{
// string constring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\ASAD\University data\Fifth Semester\Visual Programming\Project\New Project\hostel-2.mdb";
// OleDbConnection conDataBase = new OleDbConnection(constring);
// OleDbCommand cmdDataBase = new OleDbCommand("Select * from Student where StdId=" + this.metroTextBox1.Text + " and Password="******";", conDataBase);
// OleDbDataReader myReader;
// conDataBase.Open();
// myReader = cmdDataBase.ExecuteReader();
// int count = 0;
// while (myReader.Read())
// {
// count = count + 1;
// }
// if (count == 1)
// {
// MessageBox.Show("Login Successful");
// this.Hide();
// //Cafe c = new Cafe();
// Studentinfo s = new Studentinfo();
// s.Show();
// }
// else if (count > 1)
// {
// MessageBox.Show("Duplicate Username or Password");
// }
// else
// MessageBox.Show("Username or Password do not match");
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}