Delete row from grid (BD) website C#

Asked

Viewed 45 times

1

Good,

I need a little help because I’m building a web page that shows BD data on a grid.

I put the Update and delete button.

I managed to change the BD via the web. But I’m having trouble deleting the line.

protected void ligabd()
{
    adpt = new tb_funcoesTableAdapter();
    tabfun = new DataSet.tb_funcoesDataTable();
    // tabfun = adpt.GetData();
    adpt.Fill(tabfun);
}

protected void enchegrid()
{
    Grid.DataKeyNames = new string[] { "Id" };
    Grid.DataSource = tabfun;
    Grid.DataBind();

}


protected void Grid_RowEditing(object sender, GridViewEditEventArgs e)
{
    Grid.EditIndex = e.NewEditIndex;
    enchegrid();
}

protected void Grid_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
    Grid.EditIndex = -1;
    enchegrid();
}

protected void Grid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
    GridViewRow r = Grid.Rows[e.RowIndex];
    rfun = tabfun.FindById((int)Grid.DataKeys[e.RowIndex].Value);
    if (rfun != null)
    {
        rfun["funcao"] = ((TextBox)r.FindControl("txtfuncao")).Text;

    }
    Grid.EditIndex = -1;
    adpt = new tb_funcoesTableAdapter();
    adpt.Update(tabfun);
    adpt.Fill(tabfun);
    enchegrid();
} 

I leave here some of my code . Now I have to create this one where deletes the complete line. I have the following code and it is giving error :

 protected void Grid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
    tb_funcoesTableAdapter.Customers.Rows[0].Delete();
    enchegrid();
}

Thanks for any help that makes me realize how I can erase the line at once.

1 answer

0

  • That was my mistake. Thank you. I tried to delete the line this way but it gives me a bug in Customers. So I can delete only the line I want ? protected void Grid_rowdeleting(Object Sender, Gridviewdeleteeventargs e) { tb_functionsTableAdapter.Customers.Rows[0]. Delete(); enchegrid(); } }

  • What’s wrong with what? I don’t see your code.. And I put the last Dit so I get very confused. tb_functionsTableAdapter is what? is a right Object? and where you have the delete and update... tu commands in this function you can know which Row q you clicked.. another example: https://www.codeproject.com/Questions/252190/Row-Deleting-event-in-gridview-control debug and ve q values you have at each step.

  • I can not debug because it gives me error in the code in Customers. It is underlined

Browser other questions tagged

You are not signed in. Login or sign up in order to post.