how to get the value from datagridview to textbox in c#

[marz javier]

how to get the value from datagridview to textbox on c#?
im a beginner in c#.. and im having a hard time searching for the error free code for this.. need help!!!!

[arie]

To retrive text from one of DataGridView's cells:

string txt = (string)myDataGridView.Rows[rowindex].Cells[columnindex].Value;

where rowindex is, as the name says integer value of row index, and columnindex is integer value of collumn index of the cell you want to get.

We cast it on string to be safe (I don't remember if it'll work without the cast).

columnindex can also be a string. So, if you have a column that has a Name property set to "myColumn", you can do something like this:

string txt = (string)myDataGridView.Rows[rowindex].Cells["myColumn"].Value;

This way is less confusing if you have a lot of columns, or if they can be rearranged when program is running (property AllowUserToOrderColumns of DataGridView).

Now, you can just set Text property of your TextBox:

myTextBox.Text = txt;

[marz javier]

...what if i want to select the whole row, not just the current cell??
will i put your code on the currentcellcontent of datagridview method..?

[arie]

You can select current cell for example by clicking it - by subscribing to one of this 4 events (pick the one that suits you best):

- CellClicked http://msdn.microsoft.com/en-us/libr...cellclick.aspx
- CellContentClick http://msdn.microsoft.com/en-us/libr...tentclick.aspx
- CellContentDoubleClicked http://msdn.microsoft.com/en-us/libr...ubleclick.aspx
- CellDoubleClicked http://msdn.microsoft.com/en-us/libr...ubleclick.aspx

Or you can use the property CurrentCell and CurrentCellChanged event to update your TextBox http://msdn.microsoft.com/en-us/libr...llchanged.aspx

There are many possibilities, you just have to read through it and choose the one that you like best :)

There is also a property CurrentRow in DataGridView. But I'm afraid that you'll have to get values of its cells one by one, e.g. lets assume you have 5 columns you want to display in one TextBox, separated by spaces:

string txt = (string)myDataGridView.CurrentRow.Cells["myColumn1"].Value;
txt += " " + (string)myDataGridView.CurrentRow.Cells["myColumn2"].Value;
txt += " " + (string)myDataGridView.CurrentRow.Cells["myColumn3"].Value;
txt += " " + (string)myDataGridView.CurrentRow.Cells["myColumn4"].Value;
txt += " " + (string)myDataGridView.CurrentRow.Cells["myColumn5"].Value;
myTextBox.Text = txt;

[marz javier]

it didnt work as well.. i cant figure out why.. ;(

[arie]

What exactly is not working? Can you give a code example?

[marz javier]

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
 
            string id, name, price, desc, quan;
            id = Convert.ToString(dataGridView1.SelectedRows[0].Cells[0].Value);
            name = Convert.ToString(dataGridView1.SelectedRows[0].Cells[1].Value);
            price = Convert.ToString(dataGridView1.SelectedRows[0].Cells[2].Value);
            desc = Convert.ToString(dataGridView1.SelectedRows[0].Cells[3].Value);
            quan = Convert.ToString(dataGridView1.SelectedRows[0].Cells[4].Value);
            txtID.Text = id;
            txtName.Text = name;
            txtPrice.Text = price;
            txtDesc.Text = desc;
            txtQuan.Text = quan;
 
        }
 

everytime i clicked the [0][0] cells, im not retrieving all the records in that row..

[marz javier]

..thank you for a helping hand arie.. i really appreciate your help..

[arie]

I assume it works for every row except 0?

When I worked with DataGridViews I noticed that sometimes there are some strange problems when you use SelectedRows property.

Also DGW sort of creates cells "on the fly", I don't really understand the mechanism behind it, but sometimes some clells aren't accessible. Although, I never experienced this problem in CellContentClick event.

If you're using CellContentClick event, you may want to get the row you clicked this way:

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
   if (e.RowIndex>-1 && e.ColumnIndex>-1) // it's row header and column header, trying to access it may cause errors
   {
            string id, name, price, desc, quan;
            id = Convert.ToString(dataGridView1.Rows[e.RowIndex].Cells[0].Value);
            name = Convert.ToString(dataGridView1.SelectedRows[e.RowIndex].Cells[1].Value);
            price = Convert.ToString(dataGridView1.SelectedRows[e.RowIndex].Cells[2].Value);
            desc = Convert.ToString(dataGridView1.SelectedRows[e.RowIndex].Cells[3].Value);
            quan = Convert.ToString(dataGridView1.SelectedRows[e.RowIndex].Cells[4].Value);
            txtID.Text = id;
            txtName.Text = name;
            txtPrice.Text = price;
            txtDesc.Text = desc;
            txtQuan.Text = quan;
   }
}

Also, had you tried using column names instead fo indexes when you select the cell?

You may also want to check if what you're accessing exist:

object value = DataGridView1.Rows[rowindex].Cells[columnindex].Value;
    if (value is DBNull) { return; }

[marz javier]

..but why is everytime i run the program, i got this run time error..

index was out of range: must be non-negative and less than the size of collection.. how can i solve this error?
 

[arie]

in CellContentClick you have to ensure that the index you're trying to process:
- is non-negative, meaning isn't -1 (index of headers)
- less than the size of collection, meaning that it isn't the index of new row or index isn't greater than the number of rows or columns you actually have

[adriancs]

or, you can try dataGridView1.CellClick

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
        this.dataGridView1.CellClick += new DataGridViewCellEventHandler(dataGridView1_CellClick);
    }
 
    void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
    {
        if (e.RowIndex < 0 || e.ColumnIndex < 0)
            return;
 
        string id, name, price, desc, quan;
        id = dataGridView1.Rows[e.RowIndex].Cells[0].Value + "";
        name = dataGridView1.Rows[e.RowIndex].Cells[1].Value + "";
        price = dataGridView1.Rows[e.RowIndex].Cells[2].Value + "";
        desc = dataGridView1.Rows[e.RowIndex].Cells[3].Value + "";
        quan = dataGridView1.Rows[e.RowIndex].Cells[4].Value + "";
        txtID.Text = id;
        txtName.Text = name;
        txtPrice.Text = price;
        txtDesc.Text = desc;
        txtQuan.Text = quan; 
    }
}

[marz javier]

arie, its solved!! thank you so much..

[yagoob]

How are you
How Collect column from data grid view in text box