private void ShowBirthDate() { string sqlString = "SELECT BASE_CONTACTS.ID,ISNULL(BASE_CONTACTS.NAME,'')+' '+BASE_CONTACTS.SURNAME AS REFERENTE "; sqlString += "FROM BASE_CONTACTS "; sqlString += "WHERE (BASE_CONTACTS.LIMBO = 0) "; sqlString += " AND ((BASE_CONTACTS.FLAGGLOBALORPERSONAL=2 AND BASE_CONTACTS.OWNERID=" + UC.UserId + ") OR (BASE_CONTACTS.FLAGGLOBALORPERSONAL<>2)) "; sqlString += " AND (MONTH(BASE_CONTACTS.BIRTHDAY)=" + DateTime.Now.Month + " AND DAY(BASE_CONTACTS.BIRTHDAY)=" + DateTime.Now.Day + ");"; ContactBirthDate.DataSource = DatabaseConnection.CreateDataset(sqlString); ContactBirthDate.DataBind(); if (ContactBirthDate.Items.Count > 0) { ContactBirthDate.Visible = true; ContactBirthDateInfo.Visible = false; } else { ContactBirthDate.Visible = false; ContactBirthDateInfo.Visible = true; ContactBirthDateInfo.Text = Root.rm.GetString("Deftxt27"); } }