Click here to Skip to main content
15,921,959 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: design a master page Pin
Rahul Rajat Singh31-Oct-12 2:25
professionalRahul Rajat Singh31-Oct-12 2:25 
AnswerRe: design a master page Pin
jkirkerx31-Oct-12 7:23
professionaljkirkerx31-Oct-12 7:23 
AnswerRe: design a master page Pin
ZurdoDev5-Nov-12 5:42
professionalZurdoDev5-Nov-12 5:42 
AnswerRe: design a master page Pin
xut24477-Nov-12 14:49
xut24477-Nov-12 14:49 
Questioncopy folder on web server Pin
Jassim Rahma30-Oct-12 11:17
Jassim Rahma30-Oct-12 11:17 
AnswerRe: copy folder on web server Pin
Jassim Rahma1-Nov-12 11:09
Jassim Rahma1-Nov-12 11:09 
GeneralRe: copy folder on web server Pin
Vasudevan Deepak Kumar2-Nov-12 8:33
Vasudevan Deepak Kumar2-Nov-12 8:33 
QuestionI need to get schooled here on using parameters and the reader for Oracle Pin
jkirkerx30-Oct-12 8:31
professionaljkirkerx30-Oct-12 8:31 
I decided to use Oracle 11.g for a new website job I sold that sells chips.

A small project to experiment with Oracle, and see how good it works, what's up with it, it is better than SQL Server 2008

I figured out most of the stuff, got the databases, tablespaces, permissions going.

Having trouble understanding parameters, and using the OracleDataReader in asp.net, and I'm not quite sure if I used the OracleConnection and OracleCommand correctly.

1. Specified cast is not valid. I know what it means, but I'm trying to figure out a different way of expressing it below.
p_Count = oReader.GetInt32(0)         'TheCount


2. Using the Parameters, I think Oracle doesn't like the @ char in the parameter name.
I want to say "SELECT COUNT(*) FROM WWW.RC$_PRODUCTINDEX WHERE MANUFACTURE=@MANUFACTURE"
But I get a error - ORA-00936: missing expression

Anyways, I was just looking for some pointers, or just a different set of eyes on my code, most of stuff I found was for data binding.

Dim p_Count As Integer = 0

            Dim conStr As String = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DellC521-01.redcopper.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)));User Id=WWW;Password=UTF888888"
            Dim cmdQuery As String = "SELECT COUNT(*) FROM WWW.RC$_PRODUCTINDEX"
            Dim con As New OracleConnection(conStr)
            Dim cmd As New OracleCommand(cmdQuery)

            cmd.Connection = con
            cmd.CommandType = Data.CommandType.Text

            Dim param_MANUFACTURER As OracleParameter
            param_MANUFACTURER = New OracleParameter("@MANUFACTURER", OracleDbType.Varchar2, 80)
            param_MANUFACTURER.Value = m_Manufacturer
            cmd.Parameters.Add(param_MANUFACTURER)

            Try
                con.Open()
                Dim oReader As OracleDataReader = cmd.ExecuteReader
                While oReader.Read()
                    p_Count = oReader.GetInt32(0)         'TheCount
                End While

                oReader.Close()
                con.Close()
                oReader = Nothing

            Catch ex As Exception

            End Try

            con = Nothing
            cmd = Nothing
            Return p_Count

AnswerRe: I need to get schooled here on using parameters and the reader for Oracle [SOLVED] Pin
jkirkerx30-Oct-12 12:07
professionaljkirkerx30-Oct-12 12:07 
AnswerRe: I need to get schooled here on using parameters and the reader for Oracle Pin
Think On1-Nov-12 4:52
Think On1-Nov-12 4:52 
GeneralRe: I need to get schooled here on using parameters and the reader for Oracle Pin
jkirkerx1-Nov-12 12:29
professionaljkirkerx1-Nov-12 12:29 
QuestionWeb Service: consume java web service in asp.net Pin
Member 394398830-Oct-12 2:25
Member 394398830-Oct-12 2:25 
QuestionDevelop Facebook application with 'asp.net', not with 'php' Pin
ThetaClear30-Oct-12 1:52
ThetaClear30-Oct-12 1:52 
AnswerRe: Develop Facebook application with 'asp.net', not with 'php' Pin
Eddy Vluggen30-Oct-12 3:26
professionalEddy Vluggen30-Oct-12 3:26 
QuestionASP REPEATER Pin
fahad.130-Oct-12 1:19
fahad.130-Oct-12 1:19 
AnswerRe: ASP REPEATER Pin
Eddy Vluggen30-Oct-12 3:28
professionalEddy Vluggen30-Oct-12 3:28 
AnswerRe: ASP REPEATER Pin
Guptha Ch30-Oct-12 5:49
Guptha Ch30-Oct-12 5:49 
AnswerRe: ASP REPEATER Pin
jkirkerx31-Oct-12 13:13
professionaljkirkerx31-Oct-12 13:13 
QuestionDropdownlist selected item text couldnt save into database Pin
Mathan Sivanantham30-Oct-12 0:52
Mathan Sivanantham30-Oct-12 0:52 
AnswerRe: Dropdownlist selected item text couldnt save into database Pin
Richard MacCutchan30-Oct-12 1:40
mveRichard MacCutchan30-Oct-12 1:40 
AnswerRe: Dropdownlist selected item text couldnt save into database Pin
Matt U.30-Oct-12 8:21
Matt U.30-Oct-12 8:21 
AnswerRe: Dropdownlist selected item text couldnt save into database Pin
jkirkerx31-Oct-12 13:15
professionaljkirkerx31-Oct-12 13:15 
AnswerClassic ASP - Prevent Cache from being stored Pin
diegosendra29-Oct-12 18:26
diegosendra29-Oct-12 18:26 
SuggestionRe: Classic ASP - Prevent Cache from being stored Pin
Eddy Vluggen30-Oct-12 3:32
professionalEddy Vluggen30-Oct-12 3:32 
GeneralRe: Classic ASP - Prevent Cache from being stored Pin
diegosendra30-Oct-12 4:49
diegosendra30-Oct-12 4:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.