Unable to delete a row in a gridview

[mathewgk80]

Hi all,

i got an error "System.NotSupportedException: Deleting is not supported by data source 'SqlDataSource1' unless DeleteCommand is specified"
when i try to delete a row..

the code is given below..

  public void DeleteRecordByID(int catid)
    {
        try
        {
            con = new SqlConnection(connection);
            con.Open();
            SqlCommand cmd2 = new SqlCommand("delete from Categories where CategoryID=" + cid + "", con);
            cmd2.ExecuteNonQuery();
            con.Close();
            GridView1.DataBind();
        }
        catch (Exception)
        {
        }
 
 
    }
 
 
 
 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        try
        {
            if (e.CommandName == "Delete")
            {
                int categoryID = Convert.ToInt32(e.CommandArgument);
                DeleteRecordByID(categoryID);
 
            }
        }
        catch (Exception)
        {
        }
 
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        try
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                LinkButton L = (LinkButton)e.Row.FindControl("LinkButton1");
                L.Attributes.Add("onclick", "javascript:return" + "confirm('Are you sure you want to delete this record " + DataBinder.Eval(e.Row.DataItem, "CategoryID") + "')");
 
            }
        }
        catch (Exception)
        {
        }
 
    }
    protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
    {
 
    }
    protected void GridView1_RowDeleting1(object sender, GridViewDeleteEventArgs e)
    {
        try
        {
            int categoryID = (int)GridView1.DataKeys[e.RowIndex].Value;
            DeleteRecordByID(categoryID);
        }
        catch (Exception)
        {
        }
 
    }
 
 

Please help me to solve this problem...

[Frinavale]

Hi all,

i got an error "System.NotSupportedException: Deleting is not supported by data source 'SqlDataSource1' unless DeleteCommand is specified"
when i try to delete a row..

the code is given below..
Please help me to solve this problem...

I do not see a variable named SqlDataSource1 in your code.
Could you please specify which line you think is causing the problem...

According to MSDN this exception is thrown "when an invoked method is not supported, or when there is an attempt to read, seek, or write to a stream that does not support the invoked functionality".

The only recommendation I have for your right now is to make sure that your Data Source allows you to perform a delete.


-Frinny

[moggaa]

hi

on your data gird add control linked delete then in delete command

Dim SQL As String
        SQL = "delete from tablename where id= " & e.Item.Cells(0).Text & " "

thank's

Maged