Change SqlDataSource Parameter

[tshad]

I am trying to change the SQLDataSource parameter programatically but am
getting an error:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$
ConnectionStrings:CSpearAndAssociatesConnectionStr ing %>"
SelectCommand="GetQuestions" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="SurveyTestID" Type="Int32"
/>
</SelectParameters>
</asp:SqlDataSource>

I tried:

SqlDataSource1.SelectParameters["SurveyTestID"].DefaultValue =
Request("ST")

But got the error:

Property access must assign to the property or use its value.

What am I missing?

Thanks

Tom

[Alexey Smirnov]

On Sep 21, 10:47*pm, "tshad" <[e-mail]:

I am trying to change the SQLDataSource parameter programatically but am
getting an error:

* * <asp:SqlDataSource ID="SqlDataSource1" runat="server"
* * * * ConnectionString="<%$
ConnectionStrings:CSpearAndAssociatesConnectionStr ing %>"
* * * * SelectCommand="GetQuestions" SelectCommandType="StoredProcedure">
* * * * <SelectParameters>
* * * * * * <asp:Parameter DefaultValue="1" Name="SurveyTestID" Type="Int32"
/>
* * * * </SelectParameters>
* * </asp:SqlDataSource>

I tried:

* * * SqlDataSource1.SelectParameters["SurveyTestID"].DefaultValue =
Request("ST")

But got the error:

* * Property access must assign to the property or use its value.

What am I missing?

Thanks

Tom

Tom,

is it VB or C#? :-) If you're using VB, use parenthesis instead of
brackets, and vice versa

Hope this helps

[tshad]

Alexey Smirnov wrote:

On Sep 21, 10:47 pm, "tshad" <[e-mail]:

>I am trying to change the SQLDataSource parameter programatically
but am getting an error:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$
ConnectionStrings:CSpearAndAssociatesConnectionSt ring %>"
SelectCommand="GetQuestions" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="SurveyTestID" Type="Int32"
/>
</SelectParameters>
</asp:SqlDataSource>

I tried:

SqlDataSource1.SelectParameters["SurveyTestID"].DefaultValue =
Request("ST")

But got the error:

Property access must assign to the property or use its value.

What am I missing?

Thanks

Tom

Tom,

is it VB or C#? :-) If you're using VB, use parenthesis instead of
brackets, and vice versa

That was it. I am doing projects in both VB.net and C# and sometimes miss
that.

BTW, why is it SqlDataSource1.SelectParameters["SurveyTestID"].DefaultValue
and not Value?

Thanks,

Tom

Hope this helps

[Alexey Smirnov]

On Sep 21, 11:44*pm, "tshad" <[e-mail]:

Alexey Smirnov wrote:

On Sep 21, 10:47 pm, "tshad" <[e-mail]:

I am trying to change the SQLDataSource parameter programatically
but am getting an error:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$
ConnectionStrings:CSpearAndAssociatesConnectionStr ing %>"
SelectCommand="GetQuestions" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="SurveyTestID" Type="Int32"
/>
</SelectParameters>
</asp:SqlDataSource>

I tried:

SqlDataSource1.SelectParameters["SurveyTestID"].DefaultValue =
Request("ST")

But got the error:

Property access must assign to the property or use its value.

What am I missing?

Thanks

Tom

Tom,

is it VB or C#? :-) If you're using VB, use parenthesis instead of
brackets, and vice versa

That was it. *I am doing projects in both VB.net and C# and sometimes miss
that.

BTW, why is it SqlDataSource1.SelectParameters["SurveyTestID"].DefaultValue
and not Value?

Thanks,

Tom

Hope this helps

Regarding Value. As MSDN says "A string that serves as a default value
for the Parameter when the value it is bound to cannot be resolved or
is uninitialized." In your code the value comes from SurveyTestID.

http://msdn.microsoft.com/en-us/libr...aultvalue.aspx