如何更新gridcontrol

最新推荐文章于 2021-08-11 17:05:25 发布

hawaiiboys123

最新推荐文章于 2021-08-11 17:05:25 发布

阅读量888

点赞数

本文链接：https://blog.csdn.net/hawaiiboys123/article/details/2214214

版权

gridView1.CloseEditor();
gridView1.UpdateCurrentRow();

            da.UpdateCommand = new SqlCommand("update OrderDetail set OrderID=@OrderID,ProductID where id=@id", con);
            objSqlParameter = da.UpdateCommand.Parameters.Add("@id", SqlDbType.Int);
            objSqlParameter.SourceColumn = "id";
            objSqlParameter.SourceVersion = DataRowVersion.Original;

            objSqlParameter = da.UpdateCommand.Parameters.Add("@OrderID", SqlDbType.NVarChar);
            objSqlParameter.SourceColumn = "OrderID";
            objSqlParameter.SourceVersion = DataRowVersion.Current;

            objSqlParameter = da.UpdateCommand.Parameters.Add("@ProductID", SqlDbType.NVarChar);
            objSqlParameter.SourceColumn = "ProductID";
            objSqlParameter.SourceVersion = DataRowVersion.Current;

每次运行都提示必须传入参数OrderID

也就是OrderID传入不了