private void mnuTestSQL_Click(object sender, EventArgs e) { String thesql = ""; if (editBox.SelectedText != null && editBox.SelectedText.Length > 0) { thesql = editBox.SelectedText; } else { thesql = editBox.Text; } Grid = _aDataObject.DoSelect(thesql); }
public static List <String> LoadToList(String strSql, String extractField, DataBaseObjectClass aDataObject) { List <String> result = new List <string>(); DataTable dt = aDataObject.DoSelect(strSql); if (dt != null) { foreach (DataRow aRow in dt.Rows) { result.Add(aRow[extractField].ToString()); } } else { MessageBox.Show("Restriction not valid"); } return(result); }
public static List <ForeignKey> LoadToList(String strSql, DataBaseObjectClass aDataObject) { string[] fields = new string[] { "Referencing Column", "Referenced Column", "Referenced Table" }; List <ForeignKey> result = new List <ForeignKey>(); DataTable dt = aDataObject.DoSelect(strSql); if (dt != null) { foreach (DataRow aRow in dt.Rows) { result.Add(new ForeignKey(aRow[fields[0]].ToString(), aRow[fields[1]].ToString(), aRow[fields[2]].ToString())); } } else { MessageBox.Show("Restriction not valid"); } return(result); }