CODEWITHSUNDEEP
asp.netdatatable
Lea Cohen
Lea Cohen

Reputation: 8190

Datatable Compute Function for multiple columns

I want to count the number of non-null values per column in a Datatable. I could loop through the columns and use the compute function on each column, but I was wondering if there is a more efficient way to do this.

Upvotes: 0

Views: 2341

Answers (2)

Cerebrus
Cerebrus

Reputation: 25775

I think that the Compute function is quite appropriate in this context. You could use code similar to the following:

For Each col as DataColumn in myTable
  Dim aggExpr as string = string.format("Count{0}", col.ColumnName)
  Dim filterExpr as string = string.format("{0} IS NULL", col.ColumnName)
  Dim myCount as integer = CInt(myTable.Compute(aggExpr, filterExpr))
  Console.WriteLine(myCount)
Next

(Typed in here, watch for syntax)

Note that I say "similar to the following". Please add appropriate error/null value checks.

Upvotes: 1

eglasius
eglasius

Reputation: 36037

You could add a column with an expression that checks whether the rests of the columns are null, see http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression(VS.80).aspx Then you can Compute on that column.

Upvotes: 1

Related Questions