Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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

  Return to Index