如何使用c＃更新Gridview中的记录 [英] How to update a record in a Gridview using c#

问题描述

大家好。

当我尝试更新Gridview中的记录时，以下代码不会抛出任何错误，但也不会更新记录。我的代码是：

Hi Everyone.
when I try to update a record in a Gridview, following code doesnt throw any error but doesnt update the record either. my code is:

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{


    string index = e.RowIndex.ToString();

    lblSet.Text = index;

    SqlConnection con = new SqlConnection("Data Source=MEHDI-PC\\SQLEXPRESS;Initial Catalog=PIMS;Integrated Security=True");


    using (SqlCommand cmd = new SqlCommand())
    {
        string sql = "UPDATE dbo.Dwg_Register SET Ref = @Ref, Dwg_Ref = @Dwg_Ref,Title = @Title, Dwg_Received_Date = @Dwg_Received_Date, Rev = @Rev, Trade = @Trade, Type=@Type,Produced_Date=@Produced_Date,Produced_By=@Produced_By,Submittal_Ref=@Submittal_Ref,Issued_To=@Issued_To,Date_Issued = Date_Issued, Purpose = @Purpose, Status=@Status,Action_Date=@Action_Date from dbo.Dwg_Register where DwgRegID=@DwgRegID";

        cmd.Connection = con;
        con.Open();
        cmd.CommandText = sql;

        cmd.Parameters.Add(new SqlParameter("@Ref", txtRef.Text));
        cmd.Parameters.Add(new SqlParameter("@Dwg_Ref", txtDwgRef.Text));
        cmd.Parameters.Add(new SqlParameter("@Title", txtTitle.Text));
        cmd.Parameters.Add(new SqlParameter("@Dwg_Received_Date", txtDwgReceivedDate.Text == "" ? DBNull.Value : (object)txtDwgReceivedDate.Text));
        cmd.Parameters.Add(new SqlParameter("@Rev", txtRev.Text));
        cmd.Parameters.Add(new SqlParameter("@Trade", ddlTrade.Text));
        cmd.Parameters.Add(new SqlParameter("@Type", ddlType.Text));// == "" ? DBNull.Value : (object)txtDateReceived.Text));
        cmd.Parameters.Add(new SqlParameter("@Produced_Date", txtProducedDate.Text == "" ? DBNull.Value : (object)txtProducedDate.Text));
        cmd.Parameters.Add(new SqlParameter("@Produced_By", ddlProducedBy.Text));
        cmd.Parameters.Add(new SqlParameter("@Submittal_Ref", txtSubmittalRef.Text));
        cmd.Parameters.Add(new SqlParameter("@Issued_To", ddlIssuedTo.Text));
        cmd.Parameters.Add(new SqlParameter("@Date_Issued", txtDateIssued.Text == "" ? DBNull.Value : (object)txtDateIssued.Text));
        cmd.Parameters.Add(new SqlParameter("@Purpose", ddlPurpose.Text));
        cmd.Parameters.Add(new SqlParameter("@Status", ddlStatus.Text));
        cmd.Parameters.Add(new SqlParameter("@Action_Date", txtActionDate.Text == "" ? DBNull.Value : (object)txtActionDate.Text));
        cmd.Parameters.Add(new SqlParameter("@DwgRegID", int.Parse(lblSet.Text)));



        cmd.ExecuteNonQuery();

        if (con != null)
        {
            con.Close();
        }





        lblUpdate.Text = "Record updated sucessfully.";


        MultiView1.SetActiveView(ViewGrid);


        GridView1.EditIndex = -1;
        GridView1.DataBind();
    }
}

请帮我识别我的错误。

非常感谢。

Please help me identify my mistake.
Thanks a lot.

推荐答案

尝试以下链接：



http：// www .c-sharpcorner.com / uploadfile / anjudidi / select-update-and-delete-data-in-a-Asp-Net-gridview-control / [ ^ ]

try the following link:

http://www.c-sharpcorner.com/uploadfile/anjudidi/select-update-and-delete-data-in-a-Asp-Net-gridview-control/[^]

您好，请看这个链接：



插入，更新，删除Gridview ......简单方法 [ ^ ]

Hi, see this link:

Insert, Update, Delete with Gridview ... Simple Way[^]

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