C# Get Rows From DataGridView

Question

I need to get all the rows in a DataGridView in a foreach function. How can I do this?

I.E. foreach() for each row, so for each row I could run code that would utilize the first and second column data.

This is in c#

Thanks, Christian

So much better to access the DataSource the Grid is bound to. — Henk Holterman
– Henk Holterman, Commented Jun 7, 2011 at 17:31
It's not bound to one. Its supposed to be populated by the user. — Christian Stewart
– Christian Stewart, Commented Jun 7, 2011 at 17:32
I.E. I put a datagrid view in a windows Form and am letting the user create values and then get data from it. — Christian Stewart
– Christian Stewart, Commented Jun 7, 2011 at 17:33
Very rarely a good idea. A grid is a control to Present data, not a container to Store data. It can be done but that doesn't mean it's a good idea. — Henk Holterman
– Henk Holterman, Commented Jun 7, 2011 at 18:01

Brett · Accepted Answer · 2011-06-07 17:35:01Z

2

I think the best way of accessing this data is either through the Data Source:

dataGridView.DataSource = someData;
someData.property;

OR, if the user is entering data on the page, you can access from the FindControl method:

name = ((TextBox)dataGridView.Rows[e.RowIndex].FindControl("name")).Text;

In this case, if you've raised an event for a specific row, it will return EventArgs e, with a specific RowIndex. Then you can access the Column values via the ControlID within the column, such as <asp:TextBox id="name" runat="server" /> from .FindControl("name").

The important thing to remember is that you have to cast that object back to the type that it should be from the .FindControl() method.

answered Jun 7, 2011 at 17:35

Brett

4,0612 gold badges28 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alireza · Accepted Answer · 2011-06-07 17:33:40Z

2

Remember, it's always a good practice to bind the DataGridView to a data source, and then using the data source to do anything data-related. This keeps you clean from interacting with the datagrid.

answered Jun 7, 2011 at 17:33

Alireza

5,5815 gold badges37 silver badges74 bronze badges

Comments

vityanya · Accepted Answer · 2011-06-07 17:30:51Z

1

foreach(DataGridViewRow row in dataGridView.Rows)
{
     //Your code here
}

answered Jun 7, 2011 at 17:30

vityanya

1,1861 gold badge8 silver badges10 bronze badges

1 Comment

Christian Stewart Over a year ago

I know this. How can I get the data from Coloum 1 and Colum 2 from this? Strings.

Collectives™ on Stack Overflow

C# Get Rows From DataGridView

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related