How to set value of a SqlDataSource parameter in HTML code?

[K B]

Hi,

I have a gridview with a SqlDataSource. One of the parameters I need to
use in the update is the logged on person. The parameter was created
automatically, but I need to override the value with the "new" person
doing the update (e.g., sUser).

How can I do this please?

<asp:Parameter Name="LastUpdatedBy" Type="String" />

Thanks!
Kit

*** Sent via Developersdex http://www.developersdex.com ***

[Dabbler]

How about:
protected void Page_Load(object sender, EventArgs e)
{
SetQueryParamter();
}
private void SetQueryParameter()
{
MySqlDataSource.SelectParameters["LastUpdatedBy"].DefaultValue = sUser;
}
"K B" wrote:

Hi,

I have a gridview with a SqlDataSource. One of the parameters I need to
use in the update is the logged on person. The parameter was created
automatically, but I need to override the value with the "new" person
doing the update (e.g., sUser).

How can I do this please?

<asp:Parameter Name="LastUpdatedBy" Type="String" />

Thanks!
Kit

*** Sent via Developersdex http://www.developersdex.com ***

[Kees de Winter]

That should work. An alternative would be to put the following in the
Page_Load:

SQLDataSource.UpdateParameters.Add(ParameterNameWi thoutTheAtSymbol, Value)
Where you need to make sure that the parameter is not yet created.
(thanks to 'clickon' who answered the same kind of question to me
yesterday).

--
Kees de Winter
"Dabbler" <Da*****@discussions.microsoft.com> wrote in message
news:CF**********************************@microsof t.com...

How about:
protected void Page_Load(object sender, EventArgs e)
{
SetQueryParamter();
}
private void SetQueryParameter()
{
MySqlDataSource.SelectParameters["LastUpdatedBy"].DefaultValue = sUser;
}
"K B" wrote:

Hi,

I have a gridview with a SqlDataSource. One of the parameters I need to
use in the update is the logged on person. The parameter was created
automatically, but I need to override the value with the "new" person
doing the update (e.g., sUser).

How can I do this please?

<asp:Parameter Name="LastUpdatedBy" Type="String" />

Thanks!
Kit

*** Sent via Developersdex http://www.developersdex.com ***