如何在网格视图中显示以上数据 [英] how to show above data in grid view

问题描述

EMPNO ENAME SAL SAL * 2
1234 JOHN 191.9 383.800
3242 ROSER 191.131 382.262
7788 JAMES 190.291 380.581
7839克拉189.476 378.952
110 MAHESH 188.683 377.366
102拉尼187.91 375.838






上面的日期显示在网格视图中

EMPNO ENAME SAL SAL*2
1234 JOHN 191.9 383.800
3242 ROSER 191.131 382.262
7788 JAMES 190.291 380.581
7839 CLARK 189.476 378.952
110 MAHESH 188.683 377.366
102 RANI 187.91 375.838






The above date is shown in grid view

OracleConnection cn = new OracleConnection("DataSource=crmtest;UserID=scott;Password=tiger;Unicode=True");
   OracleDataAdapter adp;
   DataSet ds = new DataSet();

   protected void Page_Load(object sender, EventArgs e)
   {
       adp = new OracleDataAdapter("select empno,ename,sal,sal*2 from emp",cn);
       adp.Fill(ds);
       GridView1.DataSource = ds;
       GridView1.DataBind();
   }

我想查看何时sal * 2列值383.800.when列值小于5 fron 383.800时，它将在下一行中添加1000自动值，例如

EMPNO ENAME SAL SAL * 2 SHG
1234 JOHN 191.9 383.800
3242 ROSER 191.131 382.262
7788 JAMES 190.291 380.581
7839克拉189.476 378.952 1000
110 MAHESH 188.683 377.366
102 RANI 187.91 375.838

i want to see when the column sal*2 value 383.800.when the column value is less then 5 fron 383.800 it will add 1000 automatic in the next row something like this

EMPNO ENAME SAL SAL*2 SHG
1234 JOHN 191.9 383.800
3242 ROSER 191.131 382.262
7788 JAMES 190.291 380.581
7839 CLARK 189.476 378.952 1000
110 MAHESH 188.683 377.366
102 RANI 187.91 375.838

推荐答案

更改查询.像
select empno,ename,sal,sal*2, (case when (sal*2) -5 > sal then sal + 1000 else sal) from emp"

Change your query. Something like
select empno,ename,sal,sal*2, (case when (sal*2) -5 > sal then sal + 1000 else sal) from emp"

这篇关于如何在网格视图中显示以上数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！