如何在C#中计算数据表大小 [英] how to calculate datatable size in C#
本文介绍了如何在C#中计算数据表大小的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在C#
解决方案
中计算数据表大小以计算行数
datatable_Name.Rows。计算
和列
datatable_Name.Columns.Count
使用System尝试此代码
使用System.Data;
公共类DataTableComputeExample
{
public static void Main()
{
//添加新数据表
DataTable dtEmployee = new数据表( 雇员);
//将3列添加到数据表
dtEmployee.Columns.Add(ID,typeof(int));
dtEmployee.Columns.Add(Name,typeof(string));
dtEmployee.Columns.Add(Salary,typeof(double));
//将行添加到数据表
dtEmployee.Rows.Add(52,Human1,21000);
dtEmployee.Rows.Add(63,Human2,22000);
dtEmployee.Rows.Add(72,Human3,23000);
dtEmployee.Rows.Add(110,Human4,24000);
Console.Write(员工数:);
Console.WriteLine(dtEmployee.Compute(Count(ID),string.Empty));
Console.Write(Maximum Salary:);
Console.WriteLine(dtEmployee.Compute(Max(Salary),string.Empty));
Console.Write(Minimum Salary:);
Console.WriteLine(dtEmployee.Compute(Min(Salary),string.Empty));
Console.Write(平均工资:);
Console.WriteLine(dtEmployee.Compute(Avg(Salary),string.Empty));
Console.Write(Sum Salary:);
Console.WriteLine(dtEmployee.Compute(Sum(Salary),string.Empty));
Console.ReadLine();
}
}
输出:
员工人数:4
最高工资:24000
最低工资:21000
平均工资:22500
总薪资:90000
how to calculate datatable size in C#
解决方案
for counting rows
datatable_Name.Rows.Count
and for columns
datatable_Name.Columns.Count
try this code for that
using System; using System.Data; public class DataTableComputeExample { public static void Main() { //adding up a new datatable DataTable dtEmployee = new DataTable("Employee"); //adding up 3 columns to datatable dtEmployee.Columns.Add("ID", typeof(int)); dtEmployee.Columns.Add("Name", typeof(string)); dtEmployee.Columns.Add("Salary", typeof(double)); //adding up rows to the datatable dtEmployee.Rows.Add(52, "Human1", 21000); dtEmployee.Rows.Add(63, "Human2", 22000); dtEmployee.Rows.Add(72, "Human3", 23000); dtEmployee.Rows.Add(110,"Human4", 24000); Console.Write("Employee Count:"); Console.WriteLine(dtEmployee.Compute("Count(ID)", string.Empty)); Console.Write("Maximum Salary:"); Console.WriteLine(dtEmployee.Compute("Max(Salary)",string.Empty)); Console.Write("Minimum Salary:"); Console.WriteLine(dtEmployee.Compute("Min(Salary)", string.Empty)); Console.Write("Average Salary:"); Console.WriteLine(dtEmployee.Compute("Avg(Salary)", string.Empty)); Console.Write("Sum Salary:"); Console.WriteLine(dtEmployee.Compute("Sum(Salary)", string.Empty)); Console.ReadLine(); } } Output: Employee Count:4 Maximum Salary:24000 Minimum Salary:21000 Average Salary:22500 Sum Salary:90000
这篇关于如何在C#中计算数据表大小的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文