using System;

using System.Data;

public class Program

{

    public static void Main()

    {

        //Init Table

        DataTable dt = new DataTable();  

        dt.TableName = "ChiTieu";

        dt.Columns.Add("Name",typeof(string)); // Datatype string  

        dt.Columns.Add("Value",typeof(int)); // DataType int  

        dt.Columns.Add("Month",typeof(int)); // DataType int  

        dt.Columns.Add("Year",typeof(int)); // DataType int

        //Add Value

        DataRow dr = dt.NewRow(); //Creating a New Row  

        dr["Name"] = "SanLuongNgo";  

        dr["Value"] = 100;

        dt.Rows.Add(dr); // Add the Row to the DataTable  

        dr = dt.NewRow();  

        dr["Name"] = "SanLuongSan";  

        dr["Value"] = 200;  

        dt.Rows.Add(dr);

        dr = dt.NewRow();  

        dr["Name"] = "SanLuongCam";  

        dr["Value"] = 999;  

        dt.Rows.Add(dr);

        //Compute

        Console.Write("Sản lượng tổng:");

        var name="SanLuongNgo";

        var total=dt.Compute("Sum(Value)",$"Name ='{name}'");

        Console.Write(total);

    }

}