使用数据表更新Gridview [英] Update Gridview using Datatable

问题描述

我正在使用数据表作为数据源来绑定Gridview
但是我已经绑定了数据，但是如何更新和删除

i am using datatable as datasource to bind Gridview
but i was done bind the data but how to update and Delete

DataTable Details = new DataTable();

           Details.Columns.Add("ID", typeof(Int32));
           Details.Columns.Add("Name", typeof(string));
           Details.Columns.Add("Number", typeof(string));

           Details.Rows.Add("1", "Vicks400", "456789456");
           Details.Rows.Add("2", "Nitrose", "468795124");
           Details.Rows.Add("3", "Nitrored", "154657894");

           ViewState["Drugs"] = Details;

private void bindGrid()
       {
           DataTable dt = (DataTable)ViewState["Drugs"];
           gvDrug.DataSource = dt;
           gvDrug.DataBind();

       }

protected void gvDrug_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            GridViewRow row = gvDrug.Rows[e.RowIndex];

           String str = ((TextBox)(row.Cells[1].Controls[0])).Text;

            int id = Convert.ToInt32(e.NewValues[0]);
           
            string name = e.NewValues[1].ToString();
            string numberR = e.NewValues[2].ToString();

            DataTable dt = (DataTable)ViewState["Drugs"];

            dt.Rows[0]["Name"] = name;
            dt.Rows[0]["Number"] = numberR;

            dt.AcceptChanges();

            gvDrug.DataSource = dt;
            gvDrug.DataBind();

但是上面的代码没有更新怎么办?需要帮助l

but above code not updating how to do? need helpfull

推荐答案

http://www.aspdotnetcodes.com/GridView_Insert_Edit_Update_Delete .aspx [ ^ ]

此代码正常工作

This code is working Fine

protected void gvDrug_RowUpdating(object sender, GridViewUpdateEventArgs e)
       {
           string name = e.NewValues[1].ToString();
           string numberR = e.NewValues[2].ToString();

           DataTable dt = (DataTable)ViewState["Drugs"];

           dt.Rows[e.RowIndex]["Name"] = name;
           dt.Rows[e.RowIndex]["Number"] = numberR;

           dt.AcceptChanges();

           gvDrug.EditIndex = -1;
           gvDrug.DataSource = dt;
           gvDrug.DataBind();

       }

尝试此链接

使用Gridview插入，更新，删除....简单方式 [ ^ ]

Try this link

Insert, Update, Delete with Gridview....simple way[^]

这篇关于使用数据表更新Gridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！