Thanks for your reply. Sorry i was out on a vaction. I am not using Oracle.ManagedDataAccess.Client(instead of System.data.Oledb provider), i cannot use Tryparse as all sql coding is done on client side aspx. Here are some the code snipetts
<asp:SqlDataSource ID="UserQuery" runat="server"
ConnectionString="<%$ ConnectionStrings:Conn1 %>"
DeleteCommand="DELETE FROM "TEST_USERS" WHERE "ID" = :ID"
InsertCommand="INSERT INTO "TEST_USERS" ("ID", "APPLICATION_CODE", "USERNAME", "FNAME", "LNAME", "ROLE_ID", "ACTIVE_FLAG", "CREATED_USER", "CREATED_DATE", "UPDATED_DATE", "UPDATED_USER") VALUES (eval.evaluation_user_seq.nextval, :APPLICATION_CODE, :USERNAME, :FNAME, :LNAME, :ROLE_ID, :ACTIVE_FLAG, :CREATED_USER, :CREATED_DATE, :UPDATED_DATE, :UPDATED_USER)"
ProviderName="<%$ ConnectionStrings:Conn1.ProviderName %>"
SelectCommand="SELECT * FROM "TEST_USERS" order by ACTIVE_FLAG desc, LNAME, FNAME"
UpdateCommand="UPDATE "TEST_USERS" SET "APP_CODE" = :APP_CODE, "USERNAME" = :USERNAME, "FNAME" = :FNAME, "LNAME" = :LNAME, "ROLE_ID" = :ROLE_ID, "ACTIVE_FLAG" = :ACTIVE_FLAG, "UPDATED_DATE" = :UPDATED_DATE, "UPDATED_USER" = :UPDATED_USER WHERE "ID" = :ID">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Decimal" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ID" Type="Decimal" />
<asp:Parameter Name="APP_CODE" Type="String" DefaultValue="APSCASE" />
<asp:Parameter Name="USERNAME" Type="String" />
<asp:Parameter Name="FNAME" Type="String" />
<asp:Parameter Name="LNAME" Type="String" />
<asp:Parameter Name="ROLE_ID" Type="Decimal" DefaultValue="0" />
<asp:SessionParameter Name="UPDATED_DATE" SessionField="CurrentDate" Type="DateTime" />
<asp:SessionParameter Name="UPDATED_USER" SessionField="logname" Type="String" />
<asp:Parameter Name="ACTIVE_FLAG" Type="String" />
</UpdateParameters>
<InsertParameters>
........
</InsertParameters>
</asp:SqlDataSource>