两个DataTable的加减乘除代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】两个DataTable的加减乘除
作者:kunkun0921 / 发布于2015/1/26/ 1135

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Text;
	using System.Data;

	namespace ConsoleApp
	{
	 /// <summary>
	 /// 重写DataTable，重载操作符
	 /// </summary>
	 class MyDataTable : DataTable
	 {
	 public static MyDataTable operator -(MyDataTable first, MyDataTable second)
	 {
	 MyDataTable temp = first;

	 for (int i = 0; i < first.Rows.Count; i++)
	 {
	 temp.Rows[i][1] = Convert.ToInt32(first.Rows[i][1]) + Convert.ToInt32(second.Rows[i][1]);
	 temp.Rows[i][2] = first.Rows[i][2].ToString() + "+" + second.Rows[i][2].ToString();
	 temp.Rows[i][3] = Convert.ToInt32(first.Rows[i][3]) - Convert.ToInt32(second.Rows[i][3]);
	 }
	 return temp;
	 }

	 public static MyDataTable operator &(MyDataTable first, MyDataTable second)
	 {
	 MyDataTable temp = first;

	 for (int i = 0; i < first.Rows.Count; i++)
	 {
	 temp.Rows[i][1] = Convert.ToInt32(first.Rows[i][1]) * Convert.ToInt32(second.Rows[i][1]);
	 temp.Rows[i][2] = first.Rows[i][2].ToString() + "/" + second.Rows[i][2].ToString();
	 temp.Rows[i][3] = Convert.ToInt32(first.Rows[i][3]) / Convert.ToInt32(second.Rows[i][3]);
	 }
	 return temp;
	 }
	 }

	 /// <summary>
	 /// 对datatable进行操作符重载
	 /// </summary>
	 class PackDataTableOperator
	 {
	 public static void Run()
	 {
	 MyDataTable dt1 = new MyDataTable();
	 dt1.Columns.AddRange(new DataColumn[] { new DataColumn("itemname", typeof(System.String)), new DataColumn("col1", typeof(System.Int32)), new DataColumn("col2", typeof(System.String)), new DataColumn("col3", typeof(System.Int32)) });
	 DataRow newRow;
	 for (int i = 0; i < 5; i++)
	 {
	 newRow = dt1.NewRow();
	 newRow["itemname"] = "item_" + i.ToString() + ":";
	 newRow["col1"] = ((i + 1) * 2).ToString();
	 newRow["col2"] = ((i + 2) * 2).ToString();
	 newRow["col3"] = ((i + 3) * 2).ToString();
	 dt1.Rows.Add(newRow);
	 }

	 MyDataTable dt2 = new MyDataTable();
	 dt2.Columns.AddRange(new DataColumn[] { new DataColumn("itemname", typeof(System.String)), new DataColumn("col1", typeof(System.Int32)), new DataColumn("col2", typeof(System.Int32)), new DataColumn("col3", typeof(System.Int32)) });
	 for (int i = 0; i < 5; i++)
	 {
	 newRow = dt2.NewRow();
	 newRow["itemname"] = "item_" + i.ToString() + ":";
	 newRow["col1"] = ((i + 2) * 3).ToString();
	 newRow["col2"] = ((i + 3) * 3).ToString();
	 newRow["col3"] = ((i + 4) * 4).ToString();
	 dt2.Rows.Add(newRow);
	 }
	 int length = dt1.Rows.Count;
	 Console.WriteLine("dt1操作前的数据:");
	 for (int i = 0; i < length; i++)
	 {
	 Console.WriteLine(dt1.Rows[i]["itemname"].ToString() + "_" + dt1.Rows[i]["col1"].ToString() + "_" + dt1.Rows[i]["col2"].ToString() + "_" + dt1.Rows[i]["col3"].ToString());
	 }

	 Console.WriteLine("dt2操作前的数据:");
	 for (int i = 0; i < length; i++)
	 {
	 Console.WriteLine(dt2.Rows[i]["itemname"].ToString() + "_" + dt2.Rows[i]["col1"].ToString() + "_" + dt2.Rows[i]["col2"].ToString() + "_" + dt2.Rows[i]["col3"].ToString());
	 }

	 Console.WriteLine("temp操作(-)后的数据:");
	 MyDataTable temp = dt1 - dt2;
	 for (int i = 0; i < length; i++)
	 {
	 Console.WriteLine(temp.Rows[i]["itemname"].ToString() + "_" + temp.Rows[i]["col1"].ToString() + "_" + temp.Rows[i]["col2"].ToString() + "_" + temp.Rows[i]["col3"].ToString());
	 }

	 Console.WriteLine("temp操作(&)后的数据:");
	 temp = dt1 & dt2;
	 for (int i = 0; i < length; i++)
	 {
	 Console.WriteLine(temp.Rows[i]["itemname"].ToString() + "_" + temp.Rows[i]["col1"].ToString() + "_" + temp.Rows[i]["col2"].ToString() + "_" + temp.Rows[i]["col3"].ToString());
	 }
	 }
	 }
	}
试试其它关键字
　DataTable　
同语言下
可能有用的
kunkun0921贡献的其它代码(40)