Example #1
0
        public PresenterQueryResult(SQLQueryResult QueryResult)
        {
            Initialize();

            SetHeaders(QueryResult);
            SetData(QueryResult);
        }
Example #2
0
        private void SetData(SQLQueryResult QueryResult)
        {
            IList<ListViewItem> listItems = new List<ListViewItem>();
            if (QueryResult.FieldInfo.Count > 0)
            {
                foreach (var row in QueryResult.Row)
                {
                    ListViewItem item = new ListViewItem(row[0].Text);
                    for (int colNum = 1; colNum < QueryResult.FieldInfo.Count; colNum++)
                    {
                        item.SubItems.Add(new ListViewItem.ListViewSubItem(item, row[colNum].Text));
                    }

                    listItems.Add(item);
                }
            }
            View.SetData(listItems.ToArray());
        }
Example #3
0
        private void SetHeaders(SQLQueryResult QueryResult)
        {
            IList<string> Headers = new List<string>();
            foreach(var header in QueryResult.FieldInfo)
            {
                Headers.Add(header.Name);
            }

            View.SetHeaders(Headers);
        }