本文介绍了gridview rowdatabound asp.net的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有bidhistory表,该表中有一个名为bidprice的字段.我想在gridview中填充出价,例如当产品1的出价为5时,因此价格较低且唯一的一个,我想获得此行.我该怎么做?请帮助我

i have bidhistory table and in that table there is one field named bidprice . i want fill bid price in gridview like when product 1 has 5 bid price so where price is lower and unique one i wanna get this row. how i do this?please help me

推荐答案

create table Bidhistory
(
  bidid int,
  bidprice int
)
insert into Bidhistory values(1,100);
insert into Bidhistory values(1,50);
insert into Bidhistory values(1,100);
insert into Bidhistory values(1,50);
insert into Bidhistory values(1,75);

select distinct MIN(bidprice) from Bidhistory



输出:

50

然后尝试将其绑定到gridview



Output:

50

and then try to bind it gridview


这篇关于gridview rowdatabound asp.net的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-13 10:05