Editable GridView with Visual Studio 2008.
Hi,
I try to create a editable gridview, i use:
- Visual Studio 2008
- Oracle 10g Client
- Provider=System.Data.OracleClient
- UPDATE Command on SQL DataSource:
UPDATE SUAT_F1_UA_DEF SET
SUAT_F1_UA_DEF_COMPR = TO_NUMBER(:SUAT_F1_UA_DEF_COMPR),
SUAT_F1_UA_DEF_PESO = TO_NUMBER(:SUAT_F1_UA_DEF_PESO),
SUAT_F1_UA_DEF_QTD = TO_NUMBER(:SUAT_F1_UA_DEF_QTD)
WHERE
V0_0_0_DATAINICIAL = TO_DATE(:V0_0_0_DATAINICIAL,'DD/MM/YYYY HH24:MI:SS'),
AND V0_0_1_DATAFINAL = TO_DATE(:V0_0_1_DATAFINAL,'DD/MM/YYYY HH24:MI:SS'),
AND V1_1_3_LOTE = :V1_1_3_LOTE,
AND SUAT_F1_UA_DEF_COD = :SUAT_F1_UA_DEF_COD,
AND SUAT_F1_UA_DEF_TIPO = :SUAT_F1_UA_DEF_TIPO,
AND SUAT_F1_UA_DEF_POSICAO = :SUAT_F1_UA_DEF_POSICAO,
AND SUAT_F1_UA_DEF_MOTIVO = :SUAT_F1_UA_DEF_MOTIVO;
I pass the values to the parameters of SqlDataSource on GridView Row Updating Event. But i receive the erros message:
"ORA-00933: SQL command not properly ended."
On the begining (when i just active edit option) i receive the message:
"ORA-01036: illegal variable name/number."
Do you how to correct this?
I tried to use ODT (http://www.oracle.com/technology/tech/dotnet/tools/index.html), but i have connection with Oracle 8i databases, so i just leave on PC de Oracle 10g Client...
Do you know if it is possible to i use ODT with Oracle 10g Client?
Thanks for your help!