public string GetNameCustomer(string cardNo) { try { string name = "TECHCOMBANK ACCOUNT"; string query = "SELECT Customer.Name FROM Account INNER JOIN Customer on Account.CustID = Customer.CustomerID INNER JOIN Card on Account.AccountID = Card.AccountID WHERE CardNo = @cardNo"; dbContext.OpenConnection(); SqlCommand cmd = new SqlCommand(query, dbContext.Connect); cmd.Parameters.AddWithValue("cardNo", cardNo); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { name = dr["Name"].ToString(); } dbContext.CloseConnection(); return(name); } catch { if (dbContext.CHECK_OPEN) { dbContext.CloseConnection(); } return(""); } }