向dataTable添加行以在需要时填充
本文关键字:填充 dataTable 添加行 | 更新日期: 2023-09-27 18:08:39
我有数据表中的数据:
Recom House 49
Recom Street 47
Recom Floor 29
Area House 5
Area Floor 1
Observ Floor 1
但是我想要这样的:
Recom House 49
Recom Street 47
Recom Floor 29
Area House 5
**Area Street 0**
Area Floor 1
**Observ House 0**
**Observ Street 0**
Observ Floor 1
我不能从存储过程中做到这一点,所以我在代码后面尝试,但我真的不知道,我尝试了一些东西,但它不起作用,并且不是最好的解决方案。
int getTotal = ((from a in dtSerieDrill.AsEnumerable()
where a.Field<int>("idTipoRevision") == Int32.Parse(dtSerie.Tables[0].Rows[i]["idTipoRevision"].ToString())
select a.Field<string>("TipoRevision")).Distinct()).ToArray().Length;
if (getTotal == arrayCat.Length)
{
auxData += "{";
auxData += "name:'" + dtSerieDrill.Rows[n]["TipoRevision"].ToString() + "',";
auxData += "y:" + Double.Parse(dtSerieDrill.Rows[n]["Total"].ToString()) + "";
auxData += "},";
} else {
for (int g = 0; g < arrayCat.Length - 1; g++)
{
arrayCat //categories(house,street,floor,etc)
if (!arrayCat[g].Equals(dtSerieDrill.Rows[n]["Especialidad"].ToString()) && !(totalAux == (g+1)))
{
auxData += "{";
auxData += "name:'" + arrayCat[g] + "',";
auxData += "y:0";
auxData += "},";
break;
} else {
auxData += "{";
auxData += "name:'" + dtSerieDrill.Rows[n]["TipoRevision"].ToString() + "',";
auxData += "y:" + Double.Parse(dtSerieDrill.Rows[n]["Total"].ToString()) + "";
auxData += "},";
break;
}
}
}
我有代码,因为我将使用它的脚本。我可以用空的total添加行或者创建一些
我认为使用数组或集合可以更容易地达到这个目标。
。
//create you context
YourContext dbContext = new YourContext();
String[] firstCategory = dbContext.Categories.Where(x => x.categoryType == "YourFirstCategoryType").ToArray();
String[] secondCategory = dbContext.Categories.Where(x => x.categoryType == "YourSecondCategoryType").ToArray();
DataTable dt = new DataTable();
dt.Columns.Add("Category1");
dt.Columns.Add("Category2");
dt.Columns.Add("Total");
foreach(var c1 in firstCategory)
foreach(var c2 in firstCategory)
{
//create a new row object
DataRow R = dt.NewRow();
//set value to the colums
R[0] = c1;
R[1] = c2;
R[2] = GetTotal(c1,c2);//GetTotal is some function that query database and returns total when you have c1 and c2 parameter, you should check is this combination doesn't exist you returns 0
dt.Rows.Add(R);
}
我希望它能帮助你。
假设您有一个DataTable dt,您可以使用dt. rows . add (parameters)