OracleDataAdapter1.SelectCommand = SelectCommand SelectCommand.Connection = Me.getOracleConnection SelectCommand.CommandText = "select shift_num from S_TR_SHIFT" OracleDataAdapter1.Fill(dsprocess1) dsprocess1.Tables(0).Rows.InsertAt(dsprocess1.Tables(0).NewRow, 0) dsprocess1.Tables(0).Rows(0).Item("SHIFT_NUM") = "--SELECT--"
SelectCommand.CommandText = "select '--SELECT--' UNION select shift_num from S_TR_SHIFT"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)