C# Datatable的Select方法
using System;
using ;
using ;
using ;
namespace TestDataTableSelect
{
class Program
{
static DataTable dt = new DataTable();
static void Main(string[] args)
{
DataColumn dc1 = new DataColumn("id");
=typeof(int);
DataColumn dc2 = new DataColumn("name");
=typeof();
(dc1);
(dc2);
for (int i = 1; i <=10;i++ )
{
DataRow dr = ();
if (i <= 5)
{
dr[0] = i;
dr[1] = i + "--" + "hello";
}
else
{
dr[0] = i;
dr[1] = i + "--" + "nihao";
}
(dr);
}
Select();
Select("id>='3' and name='3--hello'");//支持and
Select("id>='3' or id='1'");//支持or
Select("name like '%hello%'");//支持like
Select("id>5","id desc");
Select("id>5", "id desc",);
}
private static void Select()
{
DataRow[] arrayDR = ();
foreach(DataRow dr in arrayDR)
{
(dr[0].ToString()+" "+dr[1].ToString());
}
();
}
private static void Select(string filterExpression)
{
DataRow[] arrayDR = (filterExpression);
foreach (DataRow dr in arrayDR)
{
(dr[0].ToString() + " " + dr[1].ToString());
}
();
}
private static void Select(string filterExpression, string sort)
{
DataRow[] arrayDR = (filterExpression,sort);
foreach (DataRow dr in arrayDR)
{
(dr[0].ToString() + " " + dr[1].ToString());
}
();
}
private static void Select(string filterExpression, string sort, DataViewRowState recordStates)
{
DataRow[] arrayDR = (filterExpression, sort,recordStates);
foreach (DataRow dr in arrayDR)
{
(dr[0].ToString() + " " + dr[1].ToString());
}
();
}
}
}