|
 |
aspx thread: dataset vs single return value??
Message #1 by "Yu, Kevin" <kyu@N...> on Wed, 10 Oct 2001 16:32:45 -0400
|
|
I have a single value return from oracle database.
what's the simple and best way to display it
on the web page?
Kevin Yu
system.data.oledb
coop student
Western Research Center - Natural Resource Canada
email: kyu@n...
phone:(780) 987-8611
Message #2 by Todd Carrico <ToddC@m...> on Wed, 10 Oct 2001 15:36:23 -0500
|
|
OleDbCommand.ExecuteScalar();
tc
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Wednesday, October 10, 2001 3:33 PM
To: ASP+
Subject: [aspx] dataset vs single return value??
I have a single value return from oracle database.
what's the simple and best way to display it
on the web page?
Kevin Yu
system.data.oledb
coop student
Western Research Center - Natural Resource Canada
email: kyu@n...
phone:(780) 987-8611
Message #3 by "Ivan Pavlovic" <ipavlovi@y...> on Wed, 10 Oct 2001 22:48:42 +0200
|
|
>Subject: [aspx] dataset vs single return value??
>I have a single value return from oracle database.
>what's the simple and best way to display it
>on the web page?
The best way is to return scalar value from database and to dispaly it in
web label control
Message #4 by "Yu, Kevin" <kyu@N...> on Wed, 10 Oct 2001 16:48:52 -0400
|
|
more specific, please
I will find it out online, but my project is kind of in a hurry now.
thanks
-----Original Message-----
From: Todd Carrico [mailto:ToddC@m...]
Sent: Wednesday, October 10, 2001 2:36 PM
To: ASP+
Subject: [aspx] RE: dataset vs single return value??
OleDbCommand.ExecuteScalar();
tc
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Wednesday, October 10, 2001 3:33 PM
To: ASP+
Subject: [aspx] dataset vs single return value??
I have a single value return from oracle database.
what's the simple and best way to display it
on the web page?
Kevin Yu
system.data.oledb
coop student
Western Research Center - Natural Resource Canada
email: kyu@n...
phone:(780) 987-8611
Message #5 by Todd Carrico <ToddC@m...> on Wed, 10 Oct 2001 16:02:45 -0500
|
|
OleDbCommand cmd = new OleDbCommand("<getyourvalue>", objOracleConnection)
string retVal;
retVal = cmd.ExecuteScalar();
Response.Write("Returned:= " + retVal);
tc
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Wednesday, October 10, 2001 3:49 PM
To: ASP+
Subject: [aspx] RE: dataset vs single return value??
more specific, please
I will find it out online, but my project is kind of in a hurry now.
thanks
-----Original Message-----
From: Todd Carrico [mailto:ToddC@m...]
Sent: Wednesday, October 10, 2001 2:36 PM
To: ASP+
Subject: [aspx] RE: dataset vs single return value??
OleDbCommand.ExecuteScalar();
tc
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Wednesday, October 10, 2001 3:33 PM
To: ASP+
Subject: [aspx] dataset vs single return value??
I have a single value return from oracle database.
what's the simple and best way to display it
on the web page?
Kevin Yu
system.data.oledb
coop student
Western Research Center - Natural Resource Canada
email: kyu@n...
phone:(780) 987-8611
Message #6 by "Yu, Kevin" <kyu@N...> on Wed, 10 Oct 2001 16:54:24 -0400
|
|
I know, but how to bind the return value into the label?
becaues my oledbAdapter return the value into a dataset.
is there any other container to hold the value from the
adapter?
-----Original Message-----
From: Ivan Pavlovic [mailto:ipavlovi@y...]
Sent: Wednesday, October 10, 2001 2:49 PM
To: ASP+
Subject: [aspx] RE: dataset vs single return value??
>Subject: [aspx] dataset vs single return value??
>I have a single value return from oracle database.
>what's the simple and best way to display it
>on the web page?
The best way is to return scalar value from database and to dispaly it in
web label control
Message #7 by "Yu, Kevin" <kyu@N...> on Thu, 11 Oct 2001 10:01:59 -0400
|
|
thanks
-----Original Message-----
From: Todd Carrico [mailto:ToddC@m...]
Sent: Wednesday, October 10, 2001 3:03 PM
To: ASP+
Subject: [aspx] RE: dataset vs single return value??
OleDbCommand cmd = new OleDbCommand("<getyourvalue>", objOracleConnection)
string retVal;
retVal = cmd.ExecuteScalar();
Response.Write("Returned:= " + retVal);
tc
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Wednesday, October 10, 2001 3:49 PM
To: ASP+
Subject: [aspx] RE: dataset vs single return value??
more specific, please
I will find it out online, but my project is kind of in a hurry now.
thanks
-----Original Message-----
From: Todd Carrico [mailto:ToddC@m...]
Sent: Wednesday, October 10, 2001 2:36 PM
To: ASP+
Subject: [aspx] RE: dataset vs single return value??
OleDbCommand.ExecuteScalar();
tc
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Wednesday, October 10, 2001 3:33 PM
To: ASP+
Subject: [aspx] dataset vs single return value??
I have a single value return from oracle database.
what's the simple and best way to display it
on the web page?
Kevin Yu
system.data.oledb
|
|
 |