如何在gridview中解决这个问题。需要帮助。 [英] how to fix this problem in gridview. Help needed.

问题描述

我在数据库中有3行：

I have 3 rows in database:

idi name age

1 christ 24 
2 aron 26 
3 paul 20

aspx页面：

aspx page:

<asp:ImageButton ID="imgbtn" ToolTip="Click To Add " ImageUrl="~/Image/img.png" CommandArgument="addtocart" 

runat="server" Height="40" Width="30" />//this is for add button event.

<asp:ImageButton ID="delbtn" ToolTip="Click To delete" ImageUrl="~/Image/del.png" CommandName="delete" 

runat="server" Height="40" Width="30" /> // this is for delete button event.

首先，我是从数据库中选择并在gridview中绑定。

first, i am selecting from database and binding in gridview.

bind()
{
    con.open();
    
    sqlcommand cmd3 = new sqlcommand("select * from tbname where idi is not null",con);
    SqlDataAdapter adap = new SqlDataAdapter();
    Datatable dt = new Datatable();
    adap.fill(dt);
    gridview1.datasource = dt;
    gridview1.databind();
    con.close();
}
protected void c1_grid_rowcreated(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == GridViewRowType.DataRow)
    {
        ImageButton deleter = (ImageButton)e.Row.FindControl("delbtn");
        
        if (deleter != null)
        {
            deleter.CommandArgument = e.Row.RowIndex.ToString();
        }
    }
    return;
}

secondly, i am deleting one row from gridview : now let me take id 2. when i click delete button, i took id of that rowindex and i am deleting that particular row in database. see below coding and now i have two rows in databse. so, using select query i am binding again in gridview.

<pre lang="c#">protected void c1_row_deleting(object sender, GridViewDeleteEventArgs e)
{
    Label id = GridView1.Rows[e.RowIndex].FindControl("lblid") as Label;
    
    con.open();
    int idi=Convert.ToInt32(id.Text);
    string query = "delete from tbname where dbid = " + idi + " ";
    sqlcommand cmd1 = new sqlcommand(query,con);
    sqlcommand cmd2 = new sqlcommand("select * from tbname where idi is not null",con);
    SqlDataAdapter adap = new SqlDataAdapter();
    Datatable dt = new Datatable();
    adap.fill(dt);
    gridview1.datasource = dt;
    gridview1.databind();
    con.close();
}

到现在一切正常。



现在，我需要在gridview1中执行添加：

i有另一个名为gridview2的gridview。



现在我将在gridview1中重新启动删除行后（id = 2）。

till now everything works fine.

now, i need to perform th "add" in gridview1:
i have another gridview called gridview2.

now i will have rews in gridview1 after deleted rows (id = 2).

idi name age add delete

1 christ 24 addbtn deletebtn
2 aron 26 addbtn deletebtn
3 paul 20 addbtn deletebtn

当我点击gridview1中的添加时，（例如：点击idi 1行） ，那些行应该添加到gridview2中，并且必须从gridview1和数据库中删除。





需要帮助。

when i click add in gridview1, (for ex: clicking idi 1 rows), those rows should add in gridview2 and have to remove from gridview1 as well as database.


Help needed.

推荐答案

参见一个例子 - 如何将所选记录从一个GridView移动到另一个GridView [ ^ ]。



你会明白的。根据您的要求实施。

See one example- How To Move Selected Record From One GridView to another[^].

You will get the idea. Implement according to your requirements.

这篇关于如何在gridview中解决这个问题。需要帮助。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！