Setting asp:parameter at runtime - possible?

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

Hi guys

I have the following AccessDataSourc e control on my page..

<asp:AccessData Source ID="adsAllStori es" runat="server"
DataFile="~/App_Data/Stories.mdb"
SelectCommand=" SELECT StoryID, StoryTitle FROM Stories WHERE
StoryTitle LIKE '?%' ORDER BY StoryID DESC">
<SelectParamete rs>
<asp:Paramete r Type="char" DefaultValue="A " Name="AllParam" />
</SelectParameter s>
</asp:AccessDataS ource>

I also have a code generate A-Z link list, which when clicked reload the
page with the querystring ?id= <whichever letter I click>

I'm trying to change the value of the AllParam property on the datasource
when we read the querystring, but i can only find DefaultValue as a property,
and when I watch it, it says that "DefaultVal ue does not exist in the current
context".

The code I'm using in Page_PreRender is...

adsAllStories.S electParameters["AllParam"].DefaultValue = showChar; // a char

I'm not using a querystringpara meter because I'm performing other functions
on showChar before I pass it to the SelectParameter s.

But.. how can I pass it to the accessDataSourc e?!?!

Thanks,

Dan

[MasterGaurav \(www.edujini-labs.com\)]

I also have a code generate A-Z link list, which when clicked reload the

page with the querystring ?id= <whichever letter I click>

But.. how can I pass it to the accessDataSourc e?!?!

Why don't you add a "QueryStringPar amter"?

<SelectParamete rs>
<asp:SelectPara meter name='SQL_Query _Parameter_Name '
QueryStringFiel d='Query_String _Parameter_Name ' />
</SelectParameter s>
For your case:
<SelectParamete rs>
<asp:SelectPara meter name='AllParam' QueryStringFiel d='id' />
</SelectParameter s>
--
Happy Hacking,
Gaurav Vaish | www.mastergaurav.com
www.edujini-labs.com
http://eduzine.edujini-labs.com
-----------------------------------------

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

Gaurav,

I want to do something to the querystring before it's passed into the
accessdatasourc e. This is why I haven't used to <querystringopt ion.

"MasterGaur av (www.edujini-labs.com)" wrote:

I also have a code generate A-Z link list, which when clicked reload the
page with the querystring ?id= <whichever letter I click>

But.. how can I pass it to the accessDataSourc e?!?!

Why don't you add a "QueryStringPar amter"?

<SelectParamete rs>
<asp:SelectPara meter name='SQL_Query _Parameter_Name '
QueryStringFiel d='Query_String _Parameter_Name ' />
</SelectParameter s>
For your case:
<SelectParamete rs>
<asp:SelectPara meter name='AllParam' QueryStringFiel d='id' />
</SelectParameter s>
--
Happy Hacking,
Gaurav Vaish | www.mastergaurav.com
www.edujini-labs.com
http://eduzine.edujini-labs.com
-----------------------------------------

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

Howdy,

Handle AccessDataSourc e.Selecting event.
BTW I'm quessing there is an error in the query:
LIKE '?%' ORDER BY StoryID DESC
should be
LIKE ? & '%' ORDER BY StoryID DESC

Hope this helps
--
Milosz
"musosdev" wrote:

Gaurav,

I want to do something to the querystring before it's passed into the
accessdatasourc e. This is why I haven't used to <querystringopt ion.

"MasterGaur av (www.edujini-labs.com)" wrote:

I also have a code generate A-Z link list, which when clicked reload the
page with the querystring ?id= <whichever letter I click>
>

But.. how can I pass it to the accessDataSourc e?!?!

Why don't you add a "QueryStringPar amter"?

<SelectParamete rs>
<asp:SelectPara meter name='SQL_Query _Parameter_Name '
QueryStringFiel d='Query_String _Parameter_Name ' />
</SelectParameter s>
For your case:
<SelectParamete rs>
<asp:SelectPara meter name='AllParam' QueryStringFiel d='id' />
</SelectParameter s>
--
Happy Hacking,
Gaurav Vaish | www.mastergaurav.com
www.edujini-labs.com
http://eduzine.edujini-labs.com
-----------------------------------------

[Walter Wang [MSFT]]

Hi Dan,

The AccessDataSourc e.SelectParamet ers are used to define parameters. To
change the parameter value at run-time, you need to do this in the
Selecting event and use the Command.Paramet ers collection:

protected void AccessDataSourc e1_Selecting(ob ject sender,
SqlDataSourceSe lectingEventArg s e)
{
e.Command.Param eters["AllParam"].Value = ...;
}

Regards,
Walter Wang (wa****@online. microsoft.com, remove 'online.')
Microsoft Online Community Support

=============== =============== =============== =====
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=============== =============== =============== =====

This posting is provided "AS IS" with no warranties, and confers no rights.

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

Thank you both!

"Walter Wang [MSFT]" wrote:

Hi Dan,

The AccessDataSourc e.SelectParamet ers are used to define parameters. To
change the parameter value at run-time, you need to do this in the
Selecting event and use the Command.Paramet ers collection:

protected void AccessDataSourc e1_Selecting(ob ject sender,
SqlDataSourceSe lectingEventArg s e)
{
e.Command.Param eters["AllParam"].Value = ...;
}

Regards,
Walter Wang (wa****@online. microsoft.com, remove 'online.')
Microsoft Online Community Support

=============== =============== =============== =====
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=============== =============== =============== =====

This posting is provided "AS IS" with no warranties, and confers no rights.