I am working on Microsoft visual studio do net 2003.I am facing some problem while edit/delete data on database through datagrid.
When I click on button column delete it gives error "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index "

Can you help me?


regards,
muskaan.

You have an array index value that is out of range. .NET arrays and collections are 0 based unlike VB/Script where they are 1 based.

-Peter

Thanks Peter.

private void dgemp_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
    try
    {
        SqlConnection myconn=new SqlConnection(strconn);
        string mysql="delete from insertdata where fname=@fname";
        SqlCommand cmd=new SqlCommand(mysql, myconn);
        cmd.Parameters.Add(new SqlParameter("@fname", dggrid.DataKeys[e.Item.ItemIndex]).ToString());
        myconn.Open();
        cmd.ExecuteNonQuery();
        myconn.Close();
        binddata();

}
    catch(SqlException ex)
    {
        lblexec.Text =ex.Message;
    }

    catch(Exception ex)
    {
        lblexec.Text =ex.Message;
    }
}

Plz help me out.
Regards,
Muskaan.

hi,

Please Look at code

, dggrid.DataKeys[e.Item.ItemIndex]).ToString()

I think you missed a "(" before dggrid

Also try to print the e.Item.ItemIndex
and dggrid.DataKeys[e.Item.ItemIndex].ToString
and see whether you get the value

Prashant