Find cell in a gridView

Question

0.00/5 (No votes)

See more:

Am trying to get cell value from a columm and am geting the error below:

MSIL

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

This is my code but am not sure about it and i cant call the column by name it does not allow me to do that.

C#

protected void btnSearchEmployees_Click(object sender, EventArgs e)
   {
       string n = grdAvailableStuff.Rows[2].RowIndex.ToString();
       MessageBox.Show(n);
   }

Posted 16-Jun-11 7:48am

Anele Ngqandu

Add a Solution

Comments

pankajupadhyay29 16-Jun-11 14:23pm

can u provide markup means html where is this button placed? are u using auto-generated columns??

Anele Ngqandu 16-Jun-11 14:41pm

My Button

<asp:Button ID="btnSearchEmployees" runat="server" Text="..." Height="24px"
Width="64px" onclick="btnSearchEmployees_Click" />

My Gridview

<asp:GridView ID="grdAvailableStuff" runat="server" BackColor="White"
BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4"
EnableSortingAndPagingCallbacks="True" AllowPaging="True"
EditIndex="2" PageSize="5" SelectedIndex="3"
Width="525px" onrowdatabound="grdAvailableStuff_RowCreated"
>
<footerstyle backcolor="#FFFFCC" forecolor="#330099">
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
<PagerSettings NextPageText="" PreviousPageText="" />
<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
<rowstyle backcolor="White" forecolor="#330099">
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
<sortedascendingcellstyle backcolor="#FEFCEB">
<sortedascendingheaderstyle backcolor="#AF0101">
<sorteddescendingcellstyle backcolor="#F6F0C0">
<sorteddescendingheaderstyle backcolor="#7E0000">

<columns>

<asp:HyperLinkField HeaderText="Create Appointment" Text="Create Appointment"
DataNavigateUrlFormatString="FinalizeAppointment.aspx?name={0}&EmployeeID={1}" DataNavigateUrlFields="name,EmployeeID" />

below is the code to load my grid

protected void btnSearch_Click(object sender, EventArgs e)
{

populateDDLStaff();

DataTable dt = new DataTable();
systemBusinessLayer = new BusinessLayer();

dt = systemBusinessLayer.grid(DatePicker.SelectedDate.ToShortDateString());
grdAvailableStuff.DataSource = dt;
grdAvailableStuff.DataBind();

}

Below is my class

public DataTable grid(string date)
{
using (SqlConnection con = new SqlConnection(ConnString))
{
SqlCommand cmd = new SqlCommand("procAvailableStuff", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Date", SqlDbType.NVarChar));
cmd.Parameters["@Date"].Value = date;

DataTable t = new DataTable("tt");
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(t);

return t;

}

}

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Srinivas Kumar Pasumarthi · Answer 1 · 2011-06-16T08:50:00

Solution 1

when your getting the value of a cell in grid , u require to specify cell position

grid.Rows[0].Cells[0].Text.ToString();

that retrieves the cell value of first one in first row

Posted 16-Jun-11 8:50am

Srinivas Kumar Pasumarthi

Updated 17-Jun-11 4:38am

v2

divesh12 · Answer 2 · 2011-06-16T09:13:00

Solution 2

dataGridView.CurrentRow.Cells["//Column Name here"].Value

It retrieve your cell value.

Posted 16-Jun-11 9:13am

divesh12

Updated 17-Jun-11 4:38am

v2