-
June 4th, 2013, 06:51 PM
#1
Help with iterating through cells in datagrid
I need help on a program I am currently creating as all I am trying to do is read all the cells in the datagrid to see if there are any null values and then display a message. I have racked my head around this for ages and I just cant find any code to help. Below is the code I am trying to use to search through each cell but this throws an exception that datatable cannot be converted to dataset. Any help would be appreciated.
string CellVal = null;
int Rowcount = 0;
CurrencyManager cm = (CurrencyManager)this.BindingContext[this.dataGrid1.DataSource];
int rowCount = cm.Count;
int colCount = ((DataTable)this.dataGrid1.DataSource).Columns.Count;
for (int row = 0; row < rowCount; row++)
{
for (int col = 0; col < colCount; col++)
{
CellVal = this.dataGrid1[row, col].ToString();
}
}
-
June 5th, 2013, 03:47 PM
#2
Re: Help with iterating through cells in datagrid
Rather than iterating through a UI component, why not iterate through the data its bound to directly?
Below is the code I am trying to use to search through each cell but this throws an exception that datatable cannot be converted to a dataset
If the source data is a DataTable, iterate through it as a DataTable rather than a DataSet.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|