Method

ReplaceDbNull

replace dbnull

OrderBy

sort the datatable order by param sort.i.e:i.e:id desc

Where

filter the data

Rows00

return the first column of first row data.If has not data,return null.

Rows00Int

return the first column of first row data,and convert to int.If has not data,return 0.

RowsMN(int indexOfRow, int indexOfColumn)

return the N’th column of M’th row data.If has not data,return null.

RowsMN(int indexOfRow, string columnName)

return the speical name of column of M’th row data.If has not data,return null.

Skip

return the data,skip the num rows.If row count is less than num,return empty table.

Take

Take the num rows of datatable.