How to get the selected row value in datagridview control?

Question

Hi all,

i have a datagridview control

i am displaying all the students information in datagrid view based on their class.

in database i have a student table it contains no.of columns like their sno,sname,age,marks etc but iam showing only sno and sname in datagridview control

sno   sname 

1       xyz

2      abc

however every thing is fine i have done the above task.

now i want do the following task

 when the user clicks on the number in the datagridview i want show all the information of the student in a window 

for example when the user clicks on "1" on the datagridview

i want to display all the details of the number 1 student in  a new window or in messagebox.

for this purpose where should i write the code and how can i get the user selected number on the datagridview.

thanks,

murali.

---

programmer on .net

Answer 1

Is this a web app? If so, just use OnRowCommand, and in this method you can do something like this:

            string argument = Page.Request.Params.Get("__EVENTARGUMENT");
            if (argument.StartsWith("Select$"))
            {
                int id = Convert.ToInt32(argument.Remove(0, 7));
                int columm1 = Convert.ToInt32(gridview.Rows[id].Cells[0].Text);
                string columm2 = Convert.ToInt32(gridview.Rows[id].Cells[1].Text);
            }

---

Web Developer

Answer 2

Hi Norkk,

thanks for your reply 

it is not a web app

it is  a windows application and iam using c#.net 2010

---

programmer on .net

Answer 3

Hmm, so try this

        private void gridView_SelectionChanged(object sender, EventArgs e)
        {
            if (gridView.SelectedRows.Count > 0)
            {
                int id = Convert.ToInt32(gridView.SelectedRows[0].Cells["ColummID"].Value.ToString());
                string name = gridView.SelectedRows[0].Cells["ColummName"].Value.ToString();
            }
        }

---

Web Developer

Answer 4

Hi Norkk,

i tried above code it shows the following error

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

and iam using datagridview control not gridview control

---

programmer on .net

Answer 5

Yes, this code is for datagridview control.

gridView.SelectedRows[0].Cells["ColummName"].Value.ToString();

In this line the index 0 should be FIX. The only change you need to make is the name of your columm. If do you have a columm called Age, and a columm called Name, you should do this:

        private void gridView_SelectionChanged(object sender, EventArgs e)
        {
            if (gridView.SelectedRows.Count > 0)
            {
                int age = Convert.ToInt32(gridView.SelectedRows[0].Cells["Age"].Value.ToString());
                string name = gridView.SelectedRows[0].Cells["Name"].Value.ToString();
            }
        }

---

Web Developer

Answer 6

Thanks Norkk 

its working fine

but the problem is if i want to see the full data  then evrytime i need to selecting the full row.

then there is any chance,if we select any cell in the row then

i want to show the information .

---

programmer on .net

Answer 7

        private void gridview_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (gridview.SelectedCells.Count > 0)
            {
                string id = gridview.SelectedCells[0].Value.ToString();
            }
        }

---

Web Developer

Answer 8

Thanks Norkk,

for sloving this issue.

now all things are working fine.

---

programmer on .net

Answer 9

Hi Norkk,

my datagridview has looks like

sno           sname             age

1                  xxxxx             20

2                  yyyyy              22

3                  zzzzz          23

now when the user clicks any of the cell in a row i want to get his sno

for example when a user clicks on the "yyyyy" name i want to get his sno "2"

how to do this issue.?

---

programmer on .net

Answer 10

Use code similar to what Norkk posted previously, but change it as follows:

private void gridview_CellClick(object sender, DataGridViewCellEventArgs e)
{
    if (gridview.SelectedCells.Count > 0)
    {
        int i = gridview.SelectedCells[0].RowIndex;
        string sno = gridview.Rows[i].Cells[0].ValueToString();
    }
}

You should easily be able to discover this yourself with a little playing around with Intellisense.

---

~~Bonnie Berent DeWitt [C# MVP]

geek-goddess-bonnie.blogspot.com

Answer 11

If you are using a LINK BUTTON in your grid view, you can use the following code in the ROWCOMMAND method...  This code with retrieve all the values in the particular selected row.

     // to get the value of the link use the command argument 

FaultId = Convert.ToInt32(e.CommandArgument);

// to get the other column values 
UserId = Convert.ToInt32(((GridViewRow(((LinkButton)e.CommandSource).NamingContainer)).Cells[1].Text);  

Department = ((GridViewRow(((LinkButton)e.CommandSource).NamingContainer)).Cells[2].Text;

ProblemType = ((GridViewRow)(((LinkButton)e.CommandSource).NamingContainer)).Cells[3].Text;