public string Login(string name, string password) { DataTable dt; string codeName; using (CommandVirtualization command = new CommandVirtualization(SqlDepot.LoginUser())) { command.Parameters.Add("CodeName", name, null); command.Parameters.Add("Password", password, null); try { dBVirtualizationOleDB.Execute(command, "User"); dt = dBVirtualizationOleDB.Import("User"); codeName = dt.Rows[0]["CodeName"].ToString(); if ((null != codeName) && (0 < codeName.Trim().Length)) { return(ConnectionsManager.addConnection(password)); } return(null); } catch (Exception ex) { Console.WriteLine($"Exception thrown{ex.Message}"); } finally { dBVirtualizationOleDB.ClearTableFromDataSet("User"); } } return(null); }