public void checkadmin(string user, string pass)
{
string connstr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\umair\source\repos\Lib Mang Sys\Lib Mang Sys\Database1.mdf;Integrated Security=True";
using (SqlConnection conn = new SqlConnection(connstr))
{
try
{
conn.Open();
string query = "Select * from dbo.Admin";
SqlCommand command = new SqlCommand(query, conn);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string username = reader.GetString(reader.GetOrdinal("Name"));
string password = reader.GetString(reader.GetOrdinal("Password"));
if (user == username && pass == password)
{
Admin_Login a = new Admin_Login();
a.Hide();
Admin_Panel b = new Admin_Panel();
b.Show();
}
else
{
MessageBox.Show("wrong");
}
}
}
catch (Exception)
{
}
}
}
