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);
}