To Avoid showing Masterpage every time when login is not right.

See more:

C#

HI, I wrote this function on my DataAccessLayer wroking good but when i call this on login form its show the my MdiForm even username and password is wrong plz someone help me what should i do.when username and password should right then Mdiform should show otherwise again loging form show .

public void Getusernamepassword(Bussinessobject.BO EBO)
{

objconn = new SqlConnection(connectionstring);
if (objconn.State != ConnectionState.Open)
try
{
objconn.Open();
objcommand = new SqlCommand("sp_Getpassword", objconn);
objcommand.CommandType = CommandType.StoredProcedure;
objcommand.Parameters.AddWithValue("@username", EBO.Username);
objcommand.Parameters.AddWithValue("@userpassword", EBO.Userpassword);

reader = objcommand.ExecuteReader(CommandBehavior.CloseConnection );

while (reader.Read())
{
count = 0 + 1;

}

if (count == 1)
{

MessageBox.Show("Your password is correct now enjoy application !!! ....");


return;

}

else if (count== 0)
{

MessageBox.Show(" Please Input right your Username and password plz check your spellings !!!!! ");

return;

}

if (count == 2)
{

MessageBox.Show ("Duplicate Username and Password !!!....");

return;


}


}
catch
{

throw;

}
finally
{
reader.Dispose();
objconn.Close();

}


else
{
MessageBox.Show("Your connection is not Open plz check ConnectionString !!!...");
}

}

This is my login buton coding

private void button1_Click(object sender, EventArgs e)
       {
          Bussinessobject.BO EBO = new Bussinessobject.BO();
            EBO.Username = txtusername.Text;
            EBO.Userpassword = txtPassword.Text;
            Businesslayer.BAL EBAL = new Businesslayer.BAL();
            EBAL.Getusernamepassword(EBO);

          
                this.Hide();
                Masterpage mpage = new Masterpage();
                mpage.Show();
        }