怎样察看DataSet中到底有没有值？

Question

可以用
if(dataset.Table["表名"].Rows.Count!=0)
说明有值

Answer 1

public string DebugDataSet( DataSet _DataSet )
{
if ( _DataSet == null )
{
_DataSet = m_DataSet;
}
StringBuilder result = new StringBuilder();
foreach ( DataTable table in _DataSet.Tables )
{
result.AppendFormat("{0}\r\n", table.TableName);
result.Append( "<br>" );
DataRowCollection tableRows = table.Rows;
DataColumnCollection tableColumns = table.Columns;
for ( int ctrRow = 0; ctrRow < tableRows.Count; ctrRow++)
{
DataRow row = tableRows[ctrRow] as DataRow;
result.AppendFormat("Row #{0}-\r\n", ctrRow + 1);
result.Append( "<br>" );
object[] rowItems = row.ItemArray;
for (int ctrColumn = 0; ctrColumn < tableColumns.Count; ctrColumn++)
{
DataColumn column = tableColumns[ctrColumn] as DataColumn;
result.AppendFormat("\t{0}: {1}\r\n", column.ColumnName, rowItems[ctrColumn].ToString() );
result.Append( "<br>" );
}
}
result.Append("\r\n");
}
return result.ToString();
}

Answer 2

If e.CommandName = "Delete" Then
            Dim intMembersID
            intMembersID = CInt(DataGrid1.DataKeys(e.Item.ItemIndex))
            Dim rowDelete As DataSet24.managerRow
            rowDelete = DataSet24.manager.FindByid(intMembersID)
            if not rowDelete=null then
            rowDelete.Delete()
            end if
            DataGrid1.DataBind()
            SqlDataAdapter1.Update(DataSet24)