如果在datalist的itemcommand中传递相同的commandargument，则将datable列值加倍 [英] Double the datable column values based on if same commandargument is passed in itemcommand of datalist

问题描述

我有一个数据列表，它在项目模板中有按钮...

和iam使用itemid的命令参数并将其填充到一个数据表中，其中inturn绑定到gridview。当我点击按钮（通过命令参数）时，我正在填充数据表。但如果我点击相同的行，如果传递相同的命令参数，我想更新数据表特定列值而不是填充数据表中的重复行



我尝试了什么：



i一直在尝试使用数据表更新选项的替代方法但不工作。等待有利的回复

i am having a datalist which is having button inside an item template ...
and iam working with command argument for itemid..and populate it in a datatable which inturn is bind to gridview. i am populating datatable when i click on button (through command argument). but if i click on same row that is if same command argument is passed i want to update the datatable specific column values instead of populating the duplicate row in datatable

What I have tried:

i have been trying with alternate ways with the datatable update options but not working.waiting for a favourable reply

推荐答案

假设您有本地数据库实例设置或使用本地数据库来完成工作。



编写SQL命令对'Total'表进行更新，然后重新绑定到前端控件以显示更新的值。

例如

表：'总计'

Assuming you have a local database instance setup or use local db to get the job done.

Write a SQL command to do an update to a 'Total' table then re-bind to front end controls to show updated value.
e.g.
Table: 'Total'

___________________
|ItemId|Qty|OrderId|
|     1|  2|      1|
|______|___|_______|

SQL：

（我假设你正在使用MS SQL express或类似的东西）

UPDATE TOTAL SET Qty = @Qty WHERE ItemId = @ItemId AND OrderId = @OrderId。



传入一些上面带有'@'前缀名称的SQL参数，并将它们的值设置为新的Qty和item / order id。

SQL:
(I am assuming you are using MS SQL express or something like that)
UPDATE TOTAL SET Qty = @Qty WHERE ItemId = @ItemId AND OrderId = @OrderId.

Pass in some SQL parameters with the '@' prefixed names above and set their values to the new Qty and item/order id.

这篇关于如果在datalist的itemcommand中传递相同的commandargument，则将datable列值加倍的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！