我在行代码更新中得到错误，此代码数据无法更新其仅显示gridview中的旧数据。 [英] I get error in row updateing in this code data cannot be update its show only old data in gridview.

问题描述

protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
     
        GridViewRow row = (GridViewRow)GridView2.Rows[e.RowIndex];
        int BookingRefNo=int.Parse(GridView2.DataKeys[e.RowIndex].Value.ToString());
             
        string AssignedPriority = ((TextBox)row.Cells[11].Controls[0]).Text;
        string Status = ((TextBox)row.Cells[12].Controls[0]).Text;

        
        SqlConnection con1 = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand("Update TSafetyMaster set AssignedPriority=@AssignedPriority,Status=@Status where BookingRefNo=@BookingRefNo", con1);
        cmd.Parameters.Add("@BookingRefNo", SqlDbType.Int).Value = BookingRefNo;
        cmd.Parameters.Add("@AssignedPriority", SqlDbType.VarChar).Value = AssignedPriority;
        cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = Status;
        con1.Open();
        cmd.ExecuteNonQuery();
        GridView2.EditIndex=-1;
        GridView2.DataBind();
        
    }

推荐答案

safihur Ra​​human ...



USE DataSet 用于在从GridView控件更新任何行时存储临时数据。



每当你在GridView控件中对DATA进行更改时......将这些更改反映到DataSet ...然后从Griview的DataSource属性的DataSet中设置相同的表。





这是更新批量数据更改的好方法到数据库一次...





您的开放和放大的编程方法关闭数据库连接非常好...但如果你为每一行做这件事会很费时间..







快乐编程....： - ）

safihur Rahuman...

USE DataSet for storing temparary data when you update any row from GridView control..

whenever you make changes to DATA in GridView control... reflect those changes to DataSet ...and then SET the same table from DataSet for DataSource Property of Griview.


It's a good way to update bulk data changes to DATABASE Once at all...


Your programming approach of Opening & Closing Database Connection is Very Good...BUT if you do it for each Row will be time consuming..



Happy Programming....:-)

这篇关于我在行代码更新中得到错误，此代码数据无法更新其仅显示gridview中的旧数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！