How to get a specific data in gridview using c#?

Question

I was wondering how to retrieve a specific data from gridview. My database consists of columns like id, type and name. Lets say the contents of my gridview is like this example below:

Id Type Name

1 Guitar Ibanez

2 Guitar Gibson

What i want to happen is to get the value under Name, Lets say "Ibanez". I was able to retrieve the value for Id using datakeys but I can't figure out how to get the value of Name in Gridview. I included code below to better understand what i mean.

protected void GuitarBrandsGridViewBtn_Click(object sender, EventArgs e)
{
    Button btn = sender as Button;
    GridViewRow gridrow = btn.NamingContainer as GridViewRow;
    int id = Convert.ToInt32(GuitarBrandsGridView.DataKeys[gridrow.RowIndex].Value.ToString());
    con.Open();
    cmd.CommandText = "DELETE FROM [guitarBrands] WHERE id=" + id;
    cmd.Connection = con;
    int a = cmd.ExecuteNonQuery();
    con.Close();
    if (a > 0)
    {
        bindgridviewguitarbrands();
    }
    System.IO.File.Delete(@"C:\Users\User1\Documents\Visual Studio 2015\WebSites\MusicStore\Pages\GuitarItemsIbanezDetails" + id + ".aspx");
    System.IO.File.Delete(@"C:\Users\User1\Documents\Visual Studio 2015\WebSites\MusicStore\Pages\GuitarItemsIbanezDetails" + id + ".aspx.cs");

}

r u using any collections

Dev
– Dev

2017-02-16 05:15:21 +00:00
Commented Feb 16, 2017 at 5:15 — Dev
– Dev, Commented Feb 16, 2017 at 5:15

Jim W · Accepted Answer · 2017-02-16 05:18:43Z

1

You can access specific columns like this

GuitarBrandsGridView.Rows[gridrow.RowIndex].Cells[1].Text;

answered Feb 16, 2017 at 5:18

Jim W

5,0261 gold badge31 silver badges46 bronze badges

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

1 Comment

BrunoEarth Over a year ago

This is the exact answer im looking for.

nilay vayada · Accepted Answer · 2017-02-16 09:00:26Z

0

you can use template field in the grid view instead of bound field like this :

<asp:TemplateField HeaderText="Name">
     <ItemTemplate>
          <asp:Label ID="lblName" runat="server" Text='<%# Eval("ColumnNameOfYourDatasourceForName") %>' />
     </ItemTemplate>
</asp:TemplateField>

and then get the label and its text in code behind from following code :

protected void GuitarBrandsGridViewBtn_Click(object sender, EventArgs e)
{
    Button btn = sender as Button;
    GridViewRow gridrow = btn.NamingContainer as GridViewRow;

    Label lblName = gridrow.FindControl("lblName");
    string name = lblName.Text;

}

answered Feb 16, 2017 at 9:00

nilay vayada

143 bronze badges

Collectives™ on Stack Overflow

How to get a specific data in gridview using c#?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related