Looking for tutorials

Question

User347239738 posted

I am new to ASP.NET, I have been using Access for 11 years but the company wants to start using the web more as the projects I am working on now will be used in 6 states with over 300 users.   I have done about 20 of the beginners tutorials but trying to find some more specific ones now and not sure of the proper language to do my searches.

I am looking for some tutorials on the following, any help would be greatly appreciated.

Connecting to 4 tables in Oracle 11 (read only).

Joining these 4 tables by key fields.

Using something like a parameter query to generate a report to view, export,  or print.  All the Oracle data is read only.

Thanks

Answer 1

User269602965 posted

2-day developer guide (examples mysteriously omit the method for obtaining the Oracle connection string from web.confg)

http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10767.pdf

Oracle Data Provider .NET

http://download.oracle.com/docs/cd/E11882_01/win.112/e18754.pdf

Oracle connection strings

http://www.connectionstrings.com/oracle

Pro Oracle ODP.NET text book

http://www.amazon.com/ODP-NET-Oracle-Database-Experts-Voice/dp/1430228202/ref=sr_1_1?s=books&ie=UTF8&qid=1312826781&sr=1-1

Oracle 11g SQL, which include Oracle Analytics

http://www.amazon.com/Oracle-Database-Osborne-ORACLE-Press/dp/0071498508/ref=sr_1_1?s=books&ie=UTF8&qid=1312826834&sr=1-1

 

 

 

 

 

Answer 2

User347239738 posted

Thanks Lannie, I will go throught these tonight.

I just got my connection string built as I have the 4 tables linked in a query but I need to add a parameter (question) to the query and somehow I dont think it works like Access parameter queries.

 

Answer 3

User269602965 posted

No it does not.

All new.

Example passing parameters to update query using ODP.NET setting a flag in a equipment units table owned by customer sequence key X

passed to the routine

  Public Shared Sub updateUnitsActiveFlag(ByVal decCustomerSeq As Decimal)
    ' Update the UNITS.ACTIVE_FLAG on Customer set to Inactive'
    Dim connectionString As String = ConfigurationManager.ConnectionStrings("AuthenticatedOracleConnectionString").ConnectionString
    Try
      Dim SQL =
      <SQL>
      UPDATE {YOURSCHEMANAME}.UNITS
      SET ACTIVE_FLAG        = 'Inactive',
          SEND_CONTRACT_FLAG = 'Do not send'
      WHERE CUSTOMER_SEQ = :CUSTOMER_SEQ
      </SQL>
      Using conn As New OracleConnection(connectionString)
        Using cmd As New OracleCommand(SQL.Value, conn)
          cmd.Parameters.Clear()
          cmd.Parameters.Add("CUSTOMER_SEQ", OracleDbType.Decimal, decCustomerSeq, ParameterDirection.Input)
          conn.Open()
          cmd.ExecuteNonQuery()
        End Using
      End Using
    Catch ex As Exception
      AppCalls.WriteToEventLog(ex, "Updating UNITS.ACTIVE_FLAG from customer inactivation failed", "AppCalls.updateUnitsActiveFlag.vb")
    End Try
  End Sub