Question

怎么判断dataset 里面空值

Answer 1

如果是想判断dataset的单元格是否为空

需要先遍历dataSet有几张表，再逐个表内的单元判断

            DataSet ds = new DataSet();
            bool isEmpty = false;
            for (int i = 0; i < ds.Tables.Count; i++)
            {
                for (int j = 0; j < ds.Tables[i].Columns.Count; j++)
                {
                    for (int k = 0; k < ds.Tables[i].Rows.Count; k++)
                    {
                        if (string.IsNullOrEmpty(ds.Tables[i].Rows[j][k].ToString().Trim()))
                        {
                            isEmpty= true;
                            break;
                        }
                    }
                }
            }