Get a single value from SQLDataSource

[Dave]

Hi

I am using .NET 2 with c# and want to retrieve a single value from my
stored procedure.

I currently have the following code:

---------------------------------------------------------------------------------------------------------------------------------
ConnectionStrin gSettings connectionSetti ngs =
ConfigurationMa nager.Connectio nStrings["ConnectionStri ng"];

SqlDataSource ds = new SqlDataSource() ;

ds.SelectComman dType = SqlDataSourceCo mmandType.Store dProcedure;
ds.SelectComman d = "GetCustomerNam e";

ds.SelectParame ters.Add("trade rId", TypeCode.Int32, "1");

ds.Select();
---------------------------------------------------------------------------------------------------------------------------------

Obviously this won't get my customer name :(

How do I get the actual value?

Thanks!

[Siva M]

Will this of any help?
http://msdn2.microsoft.com/en-us/library/37hwc7kt.aspx

"Dave" <bu****@wizardb uy.comwrote in message
news:11******** **************@ 74g2000cwt.goog legroups.com...
Hi

I am using .NET 2 with c# and want to retrieve a single value from my
stored procedure.

I currently have the following code:

---------------------------------------------------------------------------------------------------------------------------------
ConnectionStrin gSettings connectionSetti ngs =
ConfigurationMa nager.Connectio nStrings["ConnectionStri ng"];

SqlDataSource ds = new SqlDataSource() ;

ds.SelectComman dType = SqlDataSourceCo mmandType.Store dProcedure;
ds.SelectComman d = "GetCustomerNam e";

ds.SelectParame ters.Add("trade rId", TypeCode.Int32, "1");

ds.Select();
---------------------------------------------------------------------------------------------------------------------------------

Obviously this won't get my customer name :(

How do I get the actual value?

Thanks!

[Dave]

Yeah that is how I have always done it.

Just curious if it can be done with the SQLDataSource?

[Siva M]

Yes. Set the SqlDataSource's ConnectionStrin g, SelectCommand (&
SelectParameter s if required) and call the Select method. Assuming
SqlDataSource.D ataSourceMode is set DataSet, returnedDataVie w[0][0] should
give the first column of the first row from the stored proc.

DataView returnedDataVie w= (DataView)ds.Se lect();

Is this what your looking for?

"Dave" <bu****@wizardb uy.comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .
Yeah that is how I have always done it.

Just curious if it can be done with the SQLDataSource?