如何在网格视图中显示以上数据
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 likeselect empno,ename,sal,sal*2, (case when (sal*2) -5 > sal then sal + 1000 else sal) from emp"