Grid view deleting event

Question

Hi there I am using the delete command within ASP DataGrid. When I click the delete link on the datagrid I get the following error: > Please reply as soon as possible

Rafiq Batcha · Answer

I guess the EditIndex is returning value as -1 instead Can you use e.RowIndex?

rahul pawar · Answer

protected void GridView1_RowDeleting(object sender GridViewDeleteEventArgs e) { string Query = delete from shiftshedule where emp_name='+ ((TextBox)GridView1.Rows[GridView1.EditIndex].Cells[2].Controls[0]).Text +' and date1='+((TextBox)GridView1.Rows[GridView1.EditIndex].Cells[1].Controls[0]).Text +'; SqlConnection ObjConnection = new SqlConnection(Data Source=(local);Initial Catalog=Northwind;User ID=sa;password=sa;); ObjConnection.Open(); SqlCommand ObjCommand = new SqlCommand(Query ObjConnection); ObjCommand.ExecuteNonQuery(); //ObjReader.Dispose(); ObjCommand.Dispose(); SqlDataAdapter ObjAdapter = new SqlDataAdapter(select date1emp_nameavailibility from ShiftShedule where emp_name=' + DropName.SelectedItem.Text + ' and date1 between ' + txtFrom.Text + ' and ' + txtTo.Text + '  ObjConnection); DataSet ObjDataSet = new DataSet(); ObjAdapter.Fill(ObjDataSet rahul); GridView1.DataSource = ObjDataSet.Tables[rahul]; GridView1.DataBind(); }

Yogesh Verma · Answer

Check your code...find right Cell[] value. or send Code part................