How to get complete column values from datagridview?

Question

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 (201420052012) 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

Munesh Sharma · 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 Design · Answer

Sorry my mistake this code is working unless cell values are null if (dataGridView1.Rows.Count > 0) { for (int i = 0; i { label1.Text = label1.Text +  + dataGridView1.Rows[i].Cells[1].Value.ToString() + ; } }

Saber Shaikh · Answer

in this cell i have nulll value but it not faceing problem .tostring() handle null value

RD Design · Answer

Saber & Khargesh answers are correct. if (dataGridView1.Rows.Count > 0) { for (int i = 0; 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 Shaikh · Answer

String[] Getdata=new String[ dataGridView1.Rows.Count]; if (dataGridView1.Rows.Count > 0) { for (int i = 0; i { Getdata[i] =dataGridView1.Rows[i].Cells[1].Value.ToString() ; } } 100% Correct Check This

Khargesh Rajput · Answer

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

Munesh Sharma · Answer

String[] values = new String[this.GridView1.Rows.Count]; for (int index = 0; 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 Shaikh · Answer

Your Datagridview have data 2 problem first check in cell code type your coloum no [0] or [1]

RD Design · Answer

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 Shaikh · Answer

if (dataGridView1.Rows.Count > 0) { for (int i = 0; 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/