DataTable的一些简单实用方法

本文链接：https://blog.csdn.net/qq_33630989/article/details/88840964

一.定义表格
DataTable InitDt;

二.初始化DataTable表格
private void DataTableAdd()
{
InitDt = new DataTable(“DataTable1”);
DataColumn dc = null;
dc = InitDt.Columns.Add(“ID”, Type.GetType(“System.Int32”));
dc.AutoIncrement = true;//自动增加
dc.AutoIncrementSeed = 1;//起始为1
dc.AutoIncrementStep = 1;//步长为1
dc.AllowDBNull = false;//

        dc = InitDt.Columns.Add("BarCode", Type.GetType("System.String"));
        dc = InitDt.Columns.Add("supBarCode", Type.GetType("System.String"));
        dc = InitDt.Columns.Add("cInvCode", Type.GetType("System.String"));
        dc = InitDt.Columns.Add("cInvName", Type.GetType("System.String"));
        dc = InitDt.Columns.Add("pLot", Type.GetType("System.String"));
        dc = InitDt.Columns.Add("cInvStd", Type.GetType("System.String"));
        dc = InitDt.Columns.Add("qty", Type.GetType("System.Double"));
    }

三.往表格中添加数据
DataRow newRow;
newRow =InitDt.NewRow();
newRow[“BarCode”] = drArr[0][“BarCode”].ToString();
newRow[“supBarCode”] = drArr[0][“supBarCode”].ToString();
newRow[“cInvCode”] = drArr[0][“cInvCode”].ToString();
newRow[“cInvName”] = drArr[0][“cInvName”].ToString();
newRow[“pLot”] = drArr[0][“pLot”].ToString();
newRow[“cInvStd”] = drArr[0][“cInvStd”].ToString();
newRow[“qty”] = drArr[0][“qty”].ToString();
InitDt.Rows.Add(newRow);

四.查询表格中的数据
DataRow[] drArr = dtGrid.Select(string.Format(“BarCode=’{0}’”, Code));

五.清除表格中查询出的这行数据
dtGrid.Rows.Remove(drArr[0]);

六.清空DataTable
dt.Rows.Clear();

七.改变DataTable中的值 ipickedquantity desc 按照字段进行排序并给ipickedquantity+1
DataRow[] drArr = dtGrid.Select(string.Format(“cInvName=’{0}’ AND ipickedquantity<NeedQuantity”, this.Txt_cInvName.Text), “ipickedquantity desc”);
if (drArr.Length > 0)
{
double ipickedquantity = Convert.ToDouble(drArr[0][“ipickedquantity”].ToString());
drArr[0].BeginEdit();
drArr[0][“ipickedquantity”] = ipickedquantity + 1;
drArr[0].EndEdit();
dtGrid.AcceptChanges();
}
八.求DataTable一列和
string Sum = dt.Compute(“sum(ipickedquantity)”, “true”).ToString();
九.修改DataTable的列名
Dt.Columns[“ColumnsName”].ColumnName = “NewName”;