public void initDDL()
{
//template.Bindings["Value"];
//template.Bindings["Key"];
string tableName = this["Table"].GetValue <string>();
string displayFieldName = this["DisplayField"].GetValue <string>();
valueFieldName = this["ValueField"].GetValue <string>();
SelectCriteria sc = new SelectCriteria();
sc.fields = new System.Collections.ArrayList();
sc.fields.Add(displayFieldName);
sc.fields.Add(valueFieldName);
myRows = DynamicRow.FindRows(tableName, sc);
foreach (DynamicRow row in myRows)
{
ctl.Items.Add(row[displayFieldName].AsObject());
}
ctl.SelectedIndexChanged += new EventHandler(ctl_SelectedIndexChanged);
}
public void RefreshGrid(BaseCriteriaCollection bcc) //ControlSchema template, BaseCriteriaCollection criteria=null)
{
string tableName = this["TableName"].GetValue <string>("");
string[] columns = this["Columns"].GetValue <string[]>(null);
string[] titles = this["ColumnHeaders"].GetValue <string[]>(null);
int i = 0;
DataTable dt = new DataTable();
SelectCriteria sc = new SelectCriteria();
sc.fields = new System.Collections.ArrayList();
ctl.Columns.Clear();
foreach (string column in columns)
{
WinUI.DataGridViewTextBoxColumn col = new WinUI.DataGridViewTextBoxColumn();
col.HeaderText = titles[i++];
col.DataPropertyName = column;
col.Name = column;
ctl.Columns.Add(col);
dt.Columns.Add(column);
sc.fields.Add(column);
}
if (bcc != null)
{
sc.Criteria = bcc;
}
//sc.Criteria = criteria;
DynamicRowCollection rows = DynamicRow.FindRows(tableName, sc);
for (i = 0; i < rows.Count; i++)
{
DataRow dr = dt.NewRow();
foreach (string column in columns)
{
dr[column] = rows[i][column].fValue;
}
dt.Rows.Add(dr);
}
ctl.DataSource = dt;
}
