C# DataTable Select不区分大小写通过LINQ解决

布伦鸽

已于 2024-03-29 13:53:57 修改

阅读量351

点赞数 8

文章标签： c# 服务器开发语言

于 2024-03-29 09:48:34 首次发布

本文链接：https://blog.csdn.net/Cecile0828/article/details/137134671

版权

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();
        }
    }
}