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();
}
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