DataTable query practical tutorial in C#

DataTable query

During my work, I encountered the need to conduct DataTable for querying. I briefly studied it and finally used the solution to implement it. It was simple to record it for easy use in the future.

DataTable dt = ();//Get all data of DataTable and prepare for queryDataRow[] dtRow = ("Adjustment date=‘"+()+"'");//Filter all columns that meet the conditions based on the query conditionsDataTable dtNew = ();//Clone a new table with the same structure as the original table (excluding data)foreach (DataRow item in dtRow)//Put all the competitions that meet the conditions into the new table{
  (item);
}
(dtNew);//Bind new values to the control(That is, query results)

Supplement: C# query DataTable data through LINQ, and the result generates DataTable

I won't say much nonsense, let's just read the code~

var query = from g in dt_stu.AsEnumerable()
				  group g by new { 
					  t1 = &lt;string&gt;("STU_ID"), 
					  t2 = &lt;string&gt;("CLASS_ID")
				  } into m
			select new
			{
				STU_ID = .t1,
				CLASS_ID=.t2,
				Total results = (a =&gt; &lt;decimal&gt;("score")),
				Excellent number = (a =&gt; &lt;decimal&gt;("score")&gt;95)
			};
DataTable dt_article = (query); 
 
/// &lt;summary&gt;
/// LINQ returns DataTable type/// &lt;/summary&gt;
/// &lt;typeparam name="T"&gt; &lt;/typeparam&gt;
/// &lt;param name="varlist"&gt; &lt;/param&gt;
/// &lt;returns&gt; &lt;/returns&gt;
public static DataTable ToDataTable&lt;T&gt;(IEnumerable&lt;T&gt; varlist)
{
	DataTable dtReturn = new DataTable();
 
	// column names
	PropertyInfo[] oProps = null;
 
	if (varlist == null)
		return dtReturn;
 
	foreach (T rec in varlist)
	{
		if (oProps == null)
		{
			oProps = ((Type)()).GetProperties();
			foreach (PropertyInfo pi in oProps)
			{
				Type colType = ;
 
				if (() &amp;&amp; (()
				== typeof(Nullable&lt;&gt;)))
				{
					colType = ()[0];
				}
 
				(new DataColumn(, colType));
			}
		}
 
		DataRow dr = ();
 
		foreach (PropertyInfo pi in oProps)
		{
			dr[] = (rec, null) == null ?  : 
			(rec, null);
		}
 
		(dr);
	}
	return dtReturn;
}

The above is personal experience. I hope you can give you a reference and I hope you can support me more. If there are any mistakes or no complete considerations, I would like to give you advice.