How to get complete column values from datagridview?

RD Design

Hi,
I have a datagridview with 2 columns. Like below one

Heading1	Heading 2
BMW	2014
Jaguar	2005
Honda	2012

I need to get cell values (2014,2005,2012) of "Heading 2" column in to array.Have tried this way but not really success

foreach (DataGridViewRow row in dataGridView1.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
if (cell.ColumnIndex == 1)
{
MessageBox.Show(cell.Value.ToString());
Application.Exit();
}
}
}
How can I achieve this?
Thanks

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma11y ago
Accepted answer
sorry i gave answer for gridview .. now i read it you want answer for datagridvew

for (int i = 0; i < dataGridView1.Rows.Count; i++)

colB[i] = Convert.ToString(dataGridView1.Rows[i].Cells[1].Value);
RD Design11y ago
Sorry my mistake this code is working unless cell values are null

if (dataGridView1.Rows.Count > 0)
            {
                for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
                {
                    label1.Text = label1.Text + "" + dataGridView1.Rows[i].Cells[1].Value.ToString() + ",";
                }
            }
Saber Shaikh11y ago
in this cell i have nulll value but it not faceing problem .tostring() handle null value
RD Design11y ago
Saber & Khargesh answers are correct.

if (dataGridView1.Rows.Count > 0)
            {
                for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
                {
                    label1.Text = label1.Text + "" + dataGridView1.Rows[i].Cells[1].Value.ToString() + ",";
                }
            }

But having a small issue.When there is empty cell or null value above error occurs (An unhandled exception of type System.NullReferenceException occurred).Otherwise code is working as charm.How to skip these null values and get other values?
Saber Shaikh11y ago

String[] Getdata=new String[dataGridView1.Rows.Count];
if (dataGridView1.Rows.Count > 0)
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
Getdata[i] =dataGridView1.Rows[i].Cells[1].Value.ToString() ;
}
}

100% Correct Check This
Khargesh Rajput11y ago
if (dataGridView1.Rows.Count > 0)
{
for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
{
label1.Text = label1.Text+""+dataGridView1.Rows[i].Cells[1].Value.ToString() + ",";
}
}
Munesh Sharma11y ago
String[] values = new String[this.GridView1.Rows.Count];
for (int index = 0; index < this.GridView1.Rows.Count; index++)
values[index] = this.GridView1.Rows[index].Cells[0].Text;
suppose based on column name if you want to retrieve the respective cell values then iterate over grid headerrow cells, identify the cell index then use the cellindex to read the values from the grid

you change cell value according to u
Saber Shaikh11y ago
Your Datagridview have data

2 problem first check in cell code type your coloum no [0] or [1]
RD Design11y ago
Hi Saber,

It was giving me "An unhandled exception of type 'System.NullReferenceException' occurred" error
in this line

label1.Text = label1.Text + "" + dataGridView1.Rows[i].Cells[1].Value.ToString() + ",";

Thanks
Saber Shaikh11y ago
if (dataGridView1.Rows.Count > 0)
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
label1.Text = label1.Text+""+dataGridView1.Rows[i].Cells[1].Value.ToString() + ",";
}
}

check this code 100% work

if is use full for u the select to Correct Answer

Blog: http://aspnettutorialscode.blogspot.in/