Click here to Skip to main content
15,890,336 members
Home / Discussions / ASP.NET
   

ASP.NET

 
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 
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 
Well that was interesting. This Oracle is a little different on the asp.net side

Oracle didn't like the @ char, so I changed it to :, and you can't name the parameter the same as the column name, so I change the name to just :M1

As far as getting the value, it's GetValue(0), go figure. Not sure if I should cast it to a integer.

So now I see there is a Microsoft Data Access Client for Oracle included in asp.net 4.0, and a Oracle Data Access Client, the one that ships with Oracle 11.g Express, so which one to choose?
Well I choose the one from Oracle, figured maybe it's more fine tuned, I don't know, comments are welcomed.

Well I think I'm ready to start writing code for this now. I welcome any comments or conversation on this subject.

This is what I ended up with so far, it works, but needs further testing.

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=PUBLIC_USER; Password=xxxxxxxx"
            Dim cmdQuery As String = "SELECT COUNT(*) FROM RC_PUBLIC_USER.RC$_PRODUCTINDEX WHERE MANUFACTURE=:M1"
            Dim con As New OracleConnection(conStr)
            Dim cmd As New OracleCommand(cmdQuery, con)
            cmd.CommandType = Data.CommandType.Text

            Dim param_Manufacture As OracleParameter
            param_Manufacture = New OracleParameter(":M1", OracleDbType.Varchar2, 80)
            param_Manufacture.Value = m_Manufacturer
            cmd.Parameters.Add(param_Manufacture)

            Try
                con.Open()
                Dim oReader As OracleDataReader = cmd.ExecuteReader
                While oReader.Read()
                    p_Count = oReader.GetValue(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 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 
GeneralRe: Classic ASP - Prevent Cache from being stored Pin
diegosendra30-Oct-12 7:07
diegosendra30-Oct-12 7:07 

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.