SQL DataSource parameters

[=?Utf-8?B?QnJldA==?=]

I am a VB and SQL developer but new to ASP.Net world.
I have a SQL Datasource that returns an ID of the Current user.
I've setup a second SQL Datasource that performs a SELECT statement to a
table but now need to use the WHERE criteria to capture the ID from the 1st
datasource mentioned above to query the results for the current user. Please
what is the best way or ways to accomplish this? I know I need a parameter
that is bound to a control in the form but dont know how to do this.
Also I would also like to know how to create a FUNCTION in SOURCE code that
captures the ID from the first SQL DataSource. thanks for any assistance.

[David Wier]

It all depends on where you're storing your ID - - if you have it visible,
using a control, or have it assigned to a session, etc.
As you go through the sql wizard (vs.net 2005) in configuring the
datasource, you assign the parameters, then, at that point, you choose where
the parameter is getting its data.

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Bret" <Br**@discussions.microsoft.comwrote in message
news:7A**********************************@microsof t.com...

I am a VB and SQL developer but new to ASP.Net world.
I have a SQL Datasource that returns an ID of the Current user.
I've setup a second SQL Datasource that performs a SELECT statement to a
table but now need to use the WHERE criteria to capture the ID from the

1st

datasource mentioned above to query the results for the current user.

Please

what is the best way or ways to accomplish this? I know I need a

parameter

that is bound to a control in the form but dont know how to do this.
Also I would also like to know how to create a FUNCTION in SOURCE code

that

captures the ID from the first SQL DataSource. thanks for any assistance.

[=?Utf-8?B?QnJldA==?=]

thanks for your reply David.
Okay, I would like to store the the ID in a label or text box then, how do I
display the ID results in these controls?

"David Wier" wrote:

It all depends on where you're storing your ID - - if you have it visible,
using a control, or have it assigned to a session, etc.
As you go through the sql wizard (vs.net 2005) in configuring the
datasource, you assign the parameters, then, at that point, you choose where
the parameter is getting its data.

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Bret" <Br**@discussions.microsoft.comwrote in message
news:7A**********************************@microsof t.com...

I am a VB and SQL developer but new to ASP.Net world.
I have a SQL Datasource that returns an ID of the Current user.
I've setup a second SQL Datasource that performs a SELECT statement to a
table but now need to use the WHERE criteria to capture the ID from the

1st

datasource mentioned above to query the results for the current user.

Please

what is the best way or ways to accomplish this? I know I need a

parameter

that is bound to a control in the form but dont know how to do this.
Also I would also like to know how to create a FUNCTION in SOURCE code

that

captures the ID from the first SQL DataSource. thanks for any assistance.