.NET (Core and Framework)

public bool mthOpenConnection()
{
   try
   {
      string[] datasource = File.ReadAllLines("d:\\k2.txt");
      if (datasource[0] != "")
      {
         objprop.connection = "Data Source=" + datasource[0] + ";Initial Catalog=Inventory_VS;User ID=sa;Password=sa";
         objCon = new SqlConnection(objprop.connection);
         if (objCon.State != ConnectionState.Open)
         {
            objCon.Open();
         }
      }
   }
   catch
   {
      MessageBox.Show("ENTER CORRECT DATA SOURCE NAME IN UR TEXT FILE");
      return false;
   }
   return true;
}

public DataSet mthGetLogin(Properties objproperties)
{
   if (!objDBconnection.mthOpenConnection()) 
   {
      return null;
   }
   SqlDataAdapter objDALogin = new SqlDataAdapter("sp_login", objDBconnection.objCon);
   objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@uname", objproperties.Username));
   objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@pword", objproperties.Password));
   objDALogin.SelectCommand.CommandType = CommandType.StoredProcedure;
   objDALogin.Fill(objDSLogin);
   return objDSLogin;
}

...
objproperties.Password = txtpword.Text;
objDSLogin = objfunction.mthGetLogin(objproperties);
if (objDSLogin == null) 
{
   return;
}
if (objDSLogin.Tables[0].Rows.Count > 0)
{
...