SoFunction
Updated on 2025-03-09

linq query Linq advanced query instance code

[code]
using System;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
namespace SJLERP
{
public partial class WebForm1 :
{
protected void Page_Load(object sender, EventArgs e)
{
Dictionary<string, string> cityAndNum =
(, @"[^\r].*?\r")
.Cast<Match>()
.Select(c => (, @"\s", ""))
.Aggregate(new Dictionary<string, string>(), (reval, item) =>
{
if ((item, @"[\u4e00-\u9fa5]+\d+"))
{
string word = (item, @"[\u4e00-\u9fa5]+").Value;
string num = (item, @"\d+").Value;
(word, num);
}
return reval;
});
("create table KaixuanTest ( city varchar(max),num varchar(max) ) ");
().ForEach(c =>
{
string sql = (" insert KaixuanTest select '{0}','{1}'",,);
(sql);
});
}
}
}