ASP.NET

Re: I need to get schooled here on using parameters and the reader for Oracle [SOLVED]

30-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

jkirkerx30-Oct-12 12:07

Re: I need to get schooled here on using parameters and the reader for Oracle

30-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

Think On1-Nov-12 4:52

Think On

1-Nov-12 4:52

In place of oracle connection i suggest you to go with the oledb connection, Which provided by the .net framework it self

You have to import the library as

Imports System.Data.OleDb

then your code will look like:

Dim p_Count As Integer = 0
Dim conStr As String = ""
Dim cmdQuery As String = ""
Dim con As OleDbConnection = Nothing
Dim cmd As OleDbCommand = Nothing
Dim oReader As OleDbDataReader = Nothing
Try
conStr = "<Connection string for oledb connection>"
cmdQuery = "SELECT COUNT(*) FROM WWW.RC$_PRODUCTINDEX"
con = New OleDbConnection(conStr)
cmd = New OleDbCommand(cmdQuery)
cmd.Connection = con
cmd.CommandType = Data.CommandType.Text
cmd.Parameters.Add("@MANUFACTURER", OleDbType.VarChar, 80).Value = m_Manufacturer
con.Open()
oReader = cmd.ExecuteReader
While oReader.Read()
p_Count = oReader.GetInt32(0) 'TheCount
End While
Catch ex As Exception

Finally
con.Close()
oReader = Nothing
End Try

con = Nothing
cmd = Nothing
Return p_Count

Re: I need to get schooled here on using parameters and the reader for Oracle

jkirkerx1-Nov-12 12:29

Web Service: consume java web service in asp.net

1-Nov-12 12:29

I am interested in making a universal way for all my programs to be able to switch SQL Database Programs, and I think OLEDB was going to be the standard in the future. I did some research on it during my C++ development last year, and I just need to look at my code to see what I used.

I ended up using the Oracle ODP.NET 11.2, the latest one, and finished installing the Oracle 11.g to my production database server, and setup the ODP client on the web server, so I'm ready to go.

i will tool around with teh OLEDB this weekend, and take it for a spin.

Thanks for the discussion on it, anything on the subject is welcomed.

Member 394398830-Oct-12 2:25

Member 3943988

30-Oct-12 2:25

I have a java web service, RPC that is not accessible direct creating proxy class in .net.

How can we consume java web service RPC not saop in my .net application.

I am getting error :
Client found response content type of 'multipart/related; boundary=MIMEBoundaryurn_uuid_C426126584B07577941351575273892;

Thanks,

Develop Facebook application with 'asp.net', not with 'php'

ThetaClear30-Oct-12 1:52

ThetaClear

30-Oct-12 1:52

Hi,

I want to create a Facebook application.
Form the examples on the web I see that there's a use of php on the server side.
Is there a way to create the application with asp.net web forms / asp.net MVC and achieve the same results?

Thanks,
Avi

Re: Develop Facebook application with 'asp.net', not with 'php'

Eddy Vluggen30-Oct-12 3:26

30-Oct-12 3:26

ThetaClear wrote:
Form the examples on the web I see that there's a use of php on the server side.

Outside of the server, that difference is not visible. Server code runs on the server, it's only the result that one can see.

There's an example on C# and FB here[^].

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

ASP REPEATER

fahad.130-Oct-12 1:19

fahad.1

30-Oct-12 1:19

My query is that i am doing a shopping cart site.I have a repeater control loaded with products and when user clicks on a specific product ,the selected product should get loaded to the gridview which is at the rightcorner .It should happen without postback and when user selects another product the gridview should get updated with another product.How to attain the result. Expecting ur suggestions.
Thank you

Re: ASP REPEATER

Eddy Vluggen30-Oct-12 3:28

30-Oct-12 3:28

fahad.1 wrote:
Expecting ur suggestions.

Use AJAX.

Sorry, but you'll have to research the technology and see how it will fit in your application.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: ASP REPEATER

Guptha Ch30-Oct-12 5:49

Guptha Ch

30-Oct-12 5:49

Use AJAX UpdatePanel control.
Put all the code that is being postback to the server in side the UpdatePanel control

Re: ASP REPEATER

jkirkerx31-Oct-12 13:13

Dropdownlist selected item text couldnt save into database

31-Oct-12 13:13

Your going to have to use Javascript, and create your sort of fake grid, and update that fake grid in the DOM. At the same time the item is added, you need to use a web service to update the cart with that item. So when you do a postback, all the items can repopulate that same space.

fahad.1 wrote:
.It should happen without postback

Update panels do a partial postback of the page, but it's still a postback.

The only way to get around a postback is to use a web service in the background, in combination with Javascript, to just keep manipulating the dom, until you leave the page.

As far as manipulating the Gridview in JavaScript, I have no idea how.

That's alot of work for that feature or confirmation.

Mathan Sivanantham30-Oct-12 0:52

Mathan Sivanantham

30-Oct-12 0:52

I am using dropdownlist in c# asp.net. Here one dropdown list getting data's from database and its having required field validator also.,
My ASP design coding is.,

<asp:dropdownlist id="zonename" runat="server" width="195px" tooltip="Select Zone">
<asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server" controltovalidate="zonename" errormessage="Zone Name Required" initialvalue="Select Zone">
And MY C# coding is....,

da = new MySqlDataAdapter("select name from zone", mysqlcon);
dt = new DataTable();
da.Fill(dt);
zonename.Items.Clear();
zonename.Items.Add("Select Zone");

for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
zonename.Items.Add(dt.Rows[i]["name"].ToString());
}
mysqlcon.Close();

WHEN I AM SAVING THIS DROPDOWNLIST TEXT TO THE DATABASE.,THE WORD "Select Zone" ONLY GOING TO THE DATABASE.

MY INSERT QUERY IS.,

"insert into TABLENAME(zonename) values('"+zonename.text+"')";

Here i couldnt understand what is going on.,i need to save the selected text to the database. If anybody know how to solve this problem, Please let me know.,

Thanks.,

Re: Dropdownlist selected item text couldnt save into database

Richard MacCutchan30-Oct-12 1:40

Richard MacCutchan

30-Oct-12 1:40

zonename looks like it is some sort of list so it is unlikely to have a member called text. It would also help if you formatted your code and put <pre> tags around it, to make it more readable thus:

da = new MySqlDataAdapter("select name from zone", mysqlcon);
dt = new DataTable();
da.Fill(dt);
zonename.Items.Clear();
zonename.Items.Add("Select Zone");

for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
    zonename.Items.Add(dt.Rows[i]["name"].ToString());
} 
mysqlcon.Close();

One of these days I'm going to think of a really clever signature.

Re: Dropdownlist selected item text couldnt save into database

Matt U.30-Oct-12 8:21

Matt U.

30-Oct-12 8:21

Look at the SelectedText and SelectedValue properties of the DropDownList control.

djj55: Nice but may have a permission problem
Pete O'Hanlon: He has my permission to run it.

Re: Dropdownlist selected item text couldnt save into database

jkirkerx31-Oct-12 13:15

Classic ASP - Prevent Cache from being stored

31-Oct-12 13:15

it's

ddl.items.clear();
ddl.items.add(new listitem("Select a Zone", "--")
ddl.items.add(new listitem(Name, Value));

'Check that the selection is not "--" or > 0
string pvalue = ddl.selectedvalue;
insert into table pvalue

and get the selected value of the ddl, not the selected text

diegosendra29-Oct-12 18:26

diegosendra

29-Oct-12 18:26

Hi everyone

Please find below the exact code you need in order to prevent cache from being stored. I am posting this in order to help everyone that ever needs it as I spent myself some hours this last saturday trying to do it. I saw many combinations from the same code everywhere in several forums but this is the only one that worked for me comes, as referenced below

After filling a form, then going back to the previous page and then forward back again, the form is empty as expected. Nothing is stored in the browser's cache

Hope it helps

Regards

Diego Sendra
e-mail: contact@diegosendra.com
http://www.diegosendra.com

[code]
<%
Response.buffer=true
Response.Expires = -1
Response.ExpiresAbsolute = Now() -1
Response.AddHeader "pragma", "no-store"
Response.AddHeader "cache-control","no-store, no-cache,

must-revalidate"
%>
[/code]

Eddy Vluggen30-Oct-12 3:32

30-Oct-12 3:32

dawnofdefiance wrote:
Please find below the exact code you need in order to prevent cache from being stored.

Thanks

Alas, it'll be hard to find on the forum, as new messages keep coming in. You might want to submit it as a trick; makes it a bit easier to find.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

diegosendra30-Oct-12 4:49

diegosendra

30-Oct-12 4:49

Hi, I posted it as an article instead, as suggested
Thank you

Diego

diegosendra30-Oct-12 7:07

diegosendra

30-Oct-12 7:07

hi Eddie

I report a totally unrespectful behavoir from two members of this site, Guirec Le Bars and Sandeep Mewara
After following your advise to posting it as a trick I received this from these users:

Guirec Le Bars: "Not an article and not even a tip I guess..."
Sandeep Mewara: "Agree. Not even a tip."

Inmediatly the article was deleted

I am not used to this kind of treatment, I am a respected professional with over 20 years experience in the field

I just re-submitted it and I HOPE it gets published now
I have the right to judge myself if what I write is of any help or not, and not be judged by third parties

After all, I am helping others, not trying to earn a cent from this or anything else

Eddy Vluggen30-Oct-12 10:21