Exemplo n.º 1
0
        private void button11_Click(object sender, EventArgs e)
        {
            SelectCommand command = new SelectCommand(conStr);
            DataTable     tb      = command.Table("testuser").GroupWrapLeft(LogicOperator.And).Where(LogicOperator.And, "name", ValueOperator.Equal, "jack").NullWhere(LogicOperator.Or, "name", NullValueOperator.Is).GroupWrapRight().SelectDataTable();

            dataGridView1.DataSource = tb;

            //测试返回数组,取消注释加断点
            //object[][] rows = command.Table("testuser").Where(LogicOperator.And, "name", ValueOperator.Equal, "jack").SelectArray();
        }