public override ICompletionData[] GenerateCompletionData(string fileName, TextArea textArea, char charTyped)
{
ICompletionData[] data = new ICompletionData[texts.Length];
for (int i = 0; i < data.Length; i++) {
data[i] = new DefaultCompletionData(texts[i], null, ClassBrowserIconService.GotoArrowIndex);
}
return data;
}
// enumerate all tables in our database and build a table/column hashtable for code completion
void buildDataHT()
{
sqlConnection1.Open();
DataTable dt = sqlConnection1.GetSchema("Columns");
sqlConnection1.Close();
string lasttbl = (string)dt.Rows[0][2];
ICompletionData[] cd = new ICompletionData[1];
int i = 0;
int rc = 0; // rowcount
foreach(DataRow dr in dt.Rows) {
if((string)dr[2] == lasttbl) {
ICompletionData[] cdtemp = new ICompletionData[rc + 1];
cd.CopyTo(cdtemp, 0);
cd = cdtemp;
cd[rc] = new DefaultCompletionData((string)dr[3], (string)dr[7] + " " + (string)dr[3], 0);
} else {
rc = 0;
htWordNet.Add(lasttbl, cd);
cd = new ICompletionData[1];
cd[rc] = new DefaultCompletionData((string)dr[3], (string)dr[7] + " " + (string)dr[3], 0);
lasttbl = (string)dt.Rows[i][2];
}
i ++;
rc ++;
}
}