Beispiel #1
0
        private void btntest_Click(object sender, EventArgs e)
        {
            SelectStatement select = new SelectStatement();

            //select.TableName = "customer";
            //select.Fields.Add("id");
            //select.Fields.Add("name");
            //select.Fields.Add("city");
            //select.Fields.Add("age");
            //select.GroupFields.Add("city");
            select.TableName = "t";
            select.Fields.Add("a");
            select.Fields.Add("b");
            select.Fields.Add("c");
            select.GroupFields.Add("c");


            Stopwatch w = new Stopwatch();

            w.Start();
            List <object> results = new List <object>();

            results.Add(Server.ExecuteStatement(select));
            w.Stop();
            labelStatus.Text = "Elapsed : " + w.ElapsedMilliseconds;

            comResults.Items.Clear();
            foreach (var item in results)
            {
                comResults.Items.Add(new ObjectContainer()
                {
                    Label = "Result(" + item.ToString() + ")", Value = item
                });
            }
            if (comResults.Items.Count > 0)
            {
                comResults.SelectedIndex = 0;
            }
        }