using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ConsoleApp1
{
internal class Program
{
static void Main(string[] args)
{
DataTable test=new DataTable();
DataRow dataRow1 = test.NewRow();
DataRow dataRow2 = test.NewRow();
DataRow dataRow3 = test.NewRow();
DataRow[] dataRows;
test.Columns.Add("test");
dataRow1["test"] = "test";
dataRow2["test"] = "TEST";
dataRow3["test"] = "Test";
test.Rows.Add(dataRow1);
test.Rows.Add(dataRow2);
test.Rows.Add(dataRow3);
dataRows = test.Select("test='test'");
foreach(DataRow dataRow in dataRows)
{
Console.WriteLine(dataRow["test"]);
}
Console.ReadLine();
}
}
}
假如LINQ查询
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ConsoleApp1
{
internal class Program
{
static void Main(string[] args)
{
DataTable test=new DataTable();
DataRow dataRow1 = test.NewRow();
DataRow dataRow2 = test.NewRow();
DataRow dataRow3 = test.NewRow();
DataRow[] dataRows1;
test.Columns.Add("test");
dataRow1["test"] = "test";
dataRow2["test"] = "TEST";
dataRow3["test"] = "Test";
test.Rows.Add(dataRow1);
test.Rows.Add(dataRow2);
test.Rows.Add(dataRow3);
dataRows1 = test.Select("test='test'");
var dataRows2 = test.AsEnumerable().Where(row => row.Field<string>("test") == "test");
foreach(DataRow dataRow in dataRows1)
{
Console.WriteLine(dataRow["test"]);
}
Console.WriteLine("\n");
foreach (DataRow dataRow in dataRows2)
{
Console.WriteLine(dataRow["test"]);
}
Console.ReadLine();
}
}
}