如何检查数据表上的空数据字段? [英] How to check a null datafield on datatable?
问题描述
在我的情况下iam传递一个SQL查询,在我的数据表dt中包含一个名为AccountName的字段,我想在下面的查询中检查AccountName是否为空。
我尝试了什么:
我试过这个:
var query = from d in dt.AsEnumerable()
group r by r.Field< string>(0)into groupsTable
select new
{
AccountNo = groupedTable.Key,
sumOfValue = groupedTable.Sum(s => s.Field< decimal>(Gebühren) ),
};
返回数据表;
In my case iam passing a sql query , In my data table "dt" contain a field named "AccountName ", I want to check is AccountName is null or not in below query.
What I have tried:
I Tried this:
var query = from r in dt.AsEnumerable()
group r by r.Field<string>(0) into groupedTable
select new
{
AccountNo = groupedTable.Key,
sumOfValue = groupedTable.Sum(s => s.Field<decimal>("Gebühren")),
};
return datatable;
推荐答案
试试这个
try this
DataTable dt = new DataTable();
dt.Columns.Add("AccountName");
dt.Columns.Add("Gebühren");
dt.Rows.Add(null, 23);
dt.Rows.Add("abc", 3);
dt.Rows.Add("abc", 4);
dt.Rows.Add("xyz", 10);
var query = from r in dt.AsEnumerable().Where(row => (row["AccountName"] + "").Trim() != "")
group r by r["AccountName"] into groupedTable
select new
{
AccountNo = groupedTable.Key,
sumOfValue = groupedTable.Sum(s => Convert.ToDecimal(s["Gebühren"])),
};
这篇关于如何检查数据表上的空数据字段?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!