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