PLEASE PLEASE HELP ME ,ITS VERY URGENT...

I have a small comment beyond what Mahesh and others have said.

In other forums, a thread that says "urgent" in the subject might get less help since people that volunteer to help might want to avoid threads like that. Saying urgent implies that the person is in too much of a hurry to spend the time they need to spend to solve the problem.

@Mahesh,

Sorry for that!!!!!! Will take care of the rules next time.

Savita,
You need to make sure your title of the question is proper. Please help, urgent title does not make sense. To me, I have no idea unless I read your post.

Most of the questions are usually urgent here and that is why people post them here.

Thanks for playing rules!

@Vulpes & Ravishankar,

Thanks a lot for the explanation...:)

Hi Savita,
 Sorry for late reply,But Vupes already answered your question. :)

Hi Savita,
Call gridview bind outside forloop and after for loop. And I suggest you to debug you code and see the flow step by step using F11. You get the point where your method not exactly working. Could you please show all methods that you used? I mean your code.

@Ravishankar,

I have called that method in the click event of button... Why are the selected rows not getting deleted?

Hi Savita,

Call to rebind gridview with database on btnDelete_Click() method.It will fetch the item in gridview from database(You wont get deleted data).
Please let me know if its not working. :)

Hi,
Debug your solution by using breakpoint in each steps.
Ine more thing that i forgot to see in your code is that you have not used con.open() to enter in database.Hope this you will modify.

Also see this sample:
SqlCommand cmd1 = new SqlCommand(strInsert, objConn);
objConn.Open();
cmd1.ExecuteNonQuery();
objConn.Close();

Change this as...
SqlCommand cmd1 = new SqlCommand()
cmd1.Connection = objConn;
cmd1.CommandText = strDelete;
objConn.Open();
cmd1.ExecuteNonQuery();
objConn.Close();

If you see, these two scenarios both are same. What i am thinking is your query is having wrong sql.

While debugging just check strDelete, take that value and try to execute the sql itself in database.

Hi Savita,
MSDN is already having the solution for this error:
here you can see the solution of error.
http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/d6a74623-89b0-4b9a-ad07-4b8e1a79015c/

I guess there is some problem with database execution process. Rest is fine. Check this one or otherwise post you full code that you changed. I will modify and send it back to you.Hope you will get the idea :)

@Vulpes,

I tried ur suggestion but it did not work.

@Ravishankar,

I used that code,changed my code to the code in the link u have given but it is giving this error now:

ExecuteNonQuery: CommandText property has not been initialized

H Savita,
You are almost right. Just verify your code with this link. This almost similar to your code. Let me know if you need help in understanding the linked code. :)

Note:Don't forget to Bind your GridView with data after you call the delete method to reflect the changes in the GridView.

Hi,

As i told u earlier,i am getting this error:

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

try this one and let me know what error you getting

foreach(GridViewRow r in DataGridView1.Rows)
{
    int rowindex  = r.RowIndex ;
    CheckBox cb =  (CheckBox)GridView1.Rows[index].FindControl("chkDelete");
    if (cb.Checked)
    {
        currentrow = GridView1.DataKeys[index].Value.ToString();
        string constr = "Data Source=OM;Initial Catalog=TestDB;Integrated Security=True";
        string query = "Delete FROM Categories where CategoryID='" + currentrow + "'";
        SqlConnection con = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand(query,con);
        cmd.ExecuteNonQuery();

       /* Rebind your GridView */
     
        SqlCommand comm = new SqlCommand("select * from Categories", con);
        SqlDataAdapter da = new SqlDataAdapter(comm);
        DataTable dt = new DataTable();
        da.Fill(dt);
        con.Close();
      
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}

Hi,

Its still not working..

Hi,

I am also getting this error:

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

protected void btnDelete_Click(object sender, EventArgs e)
{
  string currentrow;
  for (int index = 0; index <= GridView1.Rows.Count - 1; index++)
  {
    CheckBox cb =  (CheckBox)GridView1.Rows[index].FindControl("chkDelete");
    if (cb.Checked)
    {
        currentrow = GridView1.DataKeys[index].Value.ToString();
        string constr = @"Data Source=OM;Initial Catalog=TestDB;Integrated Security=True";
        string query = @"Delete FROM Categories where CategoryID='" + currentrow + "'";
        SqlConnection con = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand(query,con);
        cmd.ExecuteNonQuery();

       /* Rebind your GridView */
     
        SqlCommand comm = new SqlCommand("select * from Categories", con);
        SqlDataAdapter da = new SqlDataAdapter(comm);
        DataTable dt = new DataTable();
        da.Fill(dt);
        con.Close();
      
        GridView1.DataSource = dt;
        GridView1.DataBind();

    }
 
  }