如何从数据表中删除行 [英] How to delete row from data table

问题描述

我在gridview2和gridview3这样的页面中有2个网格视图，当用户点击gridview3时，我获取数据并填写gridview2取决于gridview3中的唯一编号，之后用户可以删除数据并在gridview2中添加数据（不是数据库），我写的代码是从gridview2删除数据但行没有删除（空行显示）











谢谢



我的尝试：



将数据存储在dtp datatable中

in GridView3_SelectedIndexChanged

{

Session [ rdt] = dtp;

GridView2.DataSource = Session [rdt];

GridView2.DataBind（）;

}

---------------------------
GridView2_RowDeleting中的


int index = Convert.ToInt32（e.RowIndex）;

DataTable dt =（DataTable）Session [rdt] as DataTable;

dt.Rows [index] .Delete（）;

会话[rdt] = dt;

GridView2.DataSource = dt;

GridView2.DataBind（）;

解决方案

尝试写作dtp.acceptChanges（）;



看看是否有效。



如果能解决您的问题，请将此标记为已解答。

 for（int i = dtP .Rows.Count-1; i> = 0; i--）
 {
 DataRow dr = dtP.Rows [i]; 
 if（dr [name] ==Joe）
 dr.Delete（）; 
} 

希望这是你要找的..

for（int i = dtP.Rows.Count-1; i> = 0; i--）

{

if（dtP.Rows [i] [Col_Name]）=Value）

{

dtP.Rows [i] .delete（）;

}



}）

I have 2 grid views in a page like gridview2 and gridview3, when user click on gridview3 I fetch the data and filled in gridview2 depend on unique number from gridview3 after that user can delete the data and add data in gridview2 (not from database) , I written code it's deleting data from gridview2 but row was not removing (empty row showing)





thanks

What I have tried:

stored the data in dtp datatable
in GridView3_SelectedIndexChanged
{
Session["rdt"] = dtp;
GridView2.DataSource = Session["rdt"];
GridView2.DataBind();
}
---------------------------
in GridView2_RowDeleting
int index = Convert.ToInt32(e.RowIndex);
DataTable dt = (DataTable)Session["rdt"] as DataTable;
dt.Rows[index].Delete();
Session["rdt"] = dt;
GridView2.DataSource = dt;
GridView2.DataBind();

解决方案

Try writing dtp.acceptChanges();

See if this works.

Please mark this as answered if this solves your problem.

for(int i = dtP.Rows.Count-1; i >= 0; i--)
{
    DataRow dr = dtP.Rows[i];
    if (dr["name"] == "Joe")
        dr.Delete();
}

Hope this is what you are looking for..

for(int i = dtP.Rows.Count-1; i >= 0; i--)
{
if(dtP.Rows[i]["Col_Name"])="Value")
{
dtP.Rows[i].delete();
}

})

这篇关于如何从数据表中删除行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！