Hi.....need hel from u guys...would like to ask on the error with the coding below...the total dura_hour did not shown in the textbox...can anyone point out the mistake or the missing coding?
Me.OracleSelectCommand2.CommandText = "SELECT sum(DURA_HOUR) FROM DOWNTIME"
Me.OracleSelectCommand2.Connection = Me.OracleConnection2
OracleConnection2.Open()
OracleSelectCommand2.ExecuteNonQuery()
OracleDataAdapter2.Fill(DataSet141)
txtRelia.DataBind()
OracleConnection2.Close()
thx in advance