private void ExecuteSql() { if (_oracleDataTable != null) { _oracleDataTable.Dispose(); } _oracleDataTable = new OracleDataTable(_selectStatement); this.DataSource = _oracleDataTable; }
public FormCompaniesSyns(long locationid, string name, string sortname) { InitializeComponent(); _Name = name; _locationd = locationid; _sortname = sortname; OracleDataTable dt = new OracleDataTable("select * from vformcompanies_synonyms where name='" + name.ToUpper() + "'"); foreach (DataRow dr in dt.Rows) { mlSyns.AppendLine(dr["Synonym"].ToString()); } }
private void Populate() { // Fill combo-box if (cmbFormatTypes.Items.Count == 0) { DC.OracleDataTable _table = new OracleDataTable( "select tbTelephoneFormatTypes.Tbtelephoneformattypecode as ID from tbTelephoneFormatTypes"); foreach (DataRow row in _table.Rows) cmbFormatTypes.Items.Add(row["ID"]); } // Get data OracleDataTable dt = new OracleDataTable("select * from vformcompanies_formats where telephoneid=" + _Telephoneid.ToString()); foreach (DataRow row in dt.Rows) { tbTelephone.Text = row["Telephone"].ToString(); tbFormat.Text = row["Format"].ToString(); cmbFormatTypes.Text = row["Type"].ToString(); string from = row["From"].ToString(); if (from.Length > 0) { dpFrom.Value = DateTime.ParseExact(from, "yyyy-MM-dd", CultureInfo.InvariantCulture); dpFrom.Checked = true; } string to = row["To"].ToString(); if (to.Length > 0) { dpTo.Value = DateTime.ParseExact(to, "yyyy-MM-dd", CultureInfo.InvariantCulture); dpTo.Checked = true; } } dt.Connection.Close(); // Defaults if (tbFormat.Text.Length == 0) { cmbFormatTypes.Text = "SURVEY"; dpFrom.Value = DateTime.Now; dpTo.Value = DateTime.Now.AddDays(365); } // Focus tbFormat.Focus(); }
private void ViewDetails(long vkiid) { OracleDataTable details = new OracleDataTable("select * from vFormPersons_details where vkiid =" + vkiid.ToString()); foreach (DataRow row in details.Rows) { tbVkiid.Text = row["Vkiid"].ToString(); tbFirstName.Text = row["Firstname"].ToString(); tbMiddleName.Text = row["Middlename"].ToString(); tbLastName.Text = row["Lastname"].ToString(); tbTitle.Text = row["Title"].ToString(); tbMobile.Text = row["Mobile"].ToString(); tbSSNO.Text = row["Ssno"].ToString(); tbGender.Text = row["Gender"].ToString(); tbSource.Text = row["Source"].ToString(); tbSearch.Text = row["Search"].ToString(); tbUpdates.Text = row["Updates"].ToString(); HittaLink = "http://www.hitta.se/*NAME*/x/person/*VKIKEY*?vad=*NAME*".Replace("*NAME*", row["Fullname"].ToString()) .Replace("*VKIKEY*", row["Vkikey"].ToString()); if (tbSSNO.Text.Length == 12) { string first = tbFirstName.Text.Replace("å", "%e5"); string last = tbLastName.Text.Replace("å", "%e5"); string year = tbSSNO.Text.Substring(0, 4); string month = tbSSNO.Text.Substring(4, 2); month = int.Parse(month).ToString(); string day = tbSSNO.Text.Substring(6, 2); day = int.Parse(day).ToString(); BirthdayLink = "http://www.birthday.se/sok/?f=*FIRST*&l=*LAST*&y=*YEAR*&m=*MONTH*&d=*DAY*".Replace("*FIRST*", first).Replace("*LAST*", last).Replace("*YEAR*", year).Replace("*MONTH*", month).Replace("*DAY*", day); llBirthday.Enabled = true; } else { llBirthday.Enabled = false; } } }