1、DataTable筛选指定列,并是否去重复
string[] strCols = { "InNO", "ShortName", "ProductName", "SKU", "BoxNumber", "InStorageCount", "ReceiveTime", };
DataTable dt = AppDataSet.Tables[0].DefaultView.ToTable("table1", false, strCols);
DataRow[] rowsCopy = dt .Select("", "Sort Asc");
if (rowsCopy.Length == 0) { return; }
dt = rowsCopy.CopyToDataTable();
2、DataTable汇总
dtCopy.Compute("Min(PID)", null) ;
遍历DataTable,并删除相关行
private void AddTreeHR(TreeNode pNode, string pid)
{
DataRow[] rows = dtCopy.Select("PID=" + pid);
foreach (DataRow rowf in rows)
{
string deptName = (rowf["DeptName"] + string.Empty);
TreeNode node = new TreeNode();
node.Tag = rowf["UniqueID"] + string.Empty;
pNode.Nodes.Add(node);
node.Text = deptName;
AddTreeHR(node, rowf["UniqueID"] + string.Empty); //递归添加子节点
dtCopy.Rows.Remove(rowf);
dtCopy.AcceptChanges();
}
}
3、
数组匹配指定行退出
private string GetProvinceText(string province)
{
string[] mProvince = { "安徽省", "北京", "重庆", "福建省", "甘肃省", "广西", "广东省", "贵州省", "河北省", "河南省", "海南省", "湖北省", "湖南省", "黑龙江省", "吉林省", "江西省", "江苏省", "宁夏", "内蒙古", "辽宁省", "青海省", "上海", "山西省", "山东省", "四川省", "陕西省", "天津", "西藏", "新疆", "云南省", "浙江省" };
int index = -1;
for (int i = 0; i < mProvince.Length; i++)
{
var item = mProvince[i];
if (item.ToString().Contains(province) && !string.IsNullOrEmpty(province))
{
index = i;
break;
}
}
return index==-1?"":mProvince[index];
}
4、dtatatable筛选是否包含
if (AppDataSet.Tables["TA_LogisticsPZDetail"].Select("len(Col_356) >0").Length > 0)
{
datarow["Col_267"] = "是";
}
6、
DataTable转DataView筛选不包含的
DataView dvTemp = ds2.Tables[0].DefaultView;
if (cob_col089.Text.StringEqualsForSimplified("是"))
{
dvTemp.RowFilter = "col_089 LIKE ‘%回单%‘ ";
}
else if (cob_col089.Text.StringEqualsForSimplified("否"))
{
dvTemp.RowFilter = " ISNULL(col_089,‘‘) NOT LIKE ‘%回单%‘ ";
7、DataSet添加table
foreach (DataRow row in ds3.Tables[0].Rows)
{
DataSet.Tables[0].Rows.Add(row["DD_111"], row["DD_003"], row["DD_014"], row["DD_018"], time, row["DD_004"], 1, row["DD_002"]);
}
8、DataTabe指定列顺序
TempDataTable.Columns["Col_133"].SetOrdinal(31);
9、DataTable转DataView筛选不包含的
DataView dvTemp = ds2.Tables[0].DefaultView;
if (cob_col089.Text.StringEqualsForSimplified("否"))
{
dvTemp.RowFilter = " ISNULL(col_089,‘‘) NOT LIKE ‘%回单%‘ ";
}