Here ya go ! ;-)
---
protected void srcProfileView_Selecting(object sender,
SqlDataSourceSelectingEventArgs e)
{
string userVal = Request.Params("UserId");
e.Command.Parameters("@UserId").Value = userVal;
}
---
On Nov 13, 3:36 am, BigJ <[EMAIL PROTECTED]> wrote:
> Also...I used QueryStringParameter and it worked fine...but i was just
> curious as to how this could be done using C#. Thanks.
>
> On Nov 12, 2:26 pm, BigJ <[EMAIL PROTECTED]> wrote:
>
>
>
> > Thanks,
>
> > So being that I leave
>
> > <SelectParameters>
> > <asp:Parameter Name="UserId" Type="String" Size="100"
> > DefaultValue="untitled"/>
> > </SelectParameters>
>
> > in the code, and in addition use OnSelecting as follows:
>
> > <asp:SqlDataSource
> > id="srcProfileView"
> > ConnectionString="<%$ ConnectionStrings:webBlog %>"
> > SelectCommandType="StoredProcedure"
> > SelectCommand="profileInfo"
> > Runat="server"
> > OnSelecting="get_UserId">
>
> > what is the correct syntax in get_UserId to set the value of the
> > select parameter field "UserId"? The following is what I have, and it
> > is erroring out:
>
> > void get_UserId() {
> > String UserVal = Page.Request.Params.Get("UserId");
> > srcProfileView.SelectParameters.Add(new Parameter
> > (@UserId,TypeCode.String,UserVal));
> > }
>
> > Thanks
>
> > Jon
>
> > On Nov 10, 9:38 pm, Cerebrus <[EMAIL PROTECTED]> wrote:
>
> > > 1. It appears that your parameter value is equivalent to something
> > > passed in the QueryString or through the Form collection. In these
> > > cases, it would be more appropriate for you to simply use a
> > > QueryStringParameter or FormParameter. This would obviate the need for
> > > setting your Parameter on Page load.
>
> > > 2. Since you are interested only in the SelectCommand, the
> > > SqlDataSource_Selecting event is the place to set the value of the
> > > Parameter. Page_Load would not be the correct place, IMHO.
>
> > > 3. You should not be adding a new Parameter, but should instead access
> > > the declared Parameter and set it's value, or else it invalidates the
> > > purpose of using the Declarative model.
>
> > > On Nov 11, 8:35 am, BigJ <[EMAIL PROTECTED]> wrote:
>
> > > > In my sqlDataConnection I have :
>
> > > > //=============================================================
> > > > <asp:SqlDataSource
> > > > id="srcProfileView"
> > > > ConnectionString="<%$ ConnectionStrings:webBlog %>"
> > > > SelectCommandType="StoredProcedure"
> > > > SelectCommand="profileInfo"
> > > > Runat="server">
>
> > > > <SelectParameters>
> > > > <asp:Parameter Name="UserId" Type="String" Size="100"
> > > > DefaultValue="Untitled"/>
> > > > </SelectParameters>
> > > > </asp:SqlDataSource>
> > > > //=============================================================
>
> > > > However, I want to make the value of "UserId" dynamic with what's
> > > > being passed in from the URL, I took out the <selectparameter> tag and
> > > > in my Page_load I did the following:
>
> > > > //=============================================================
> > > > void Page_Load()
> > > > {
> > > > String UserId = Page.Request.Params.Get("UserId");
> > > > srcProfileView.SelectParameters.Add(new
> > > > Parameter(@UserId,TypeCode.String,UserId));
> > > > }
> > > > //=============================================================
>
> > > > From what I understand this should Add a new parameter to the
> > > > sqlDataConnection control with the name "UserId" and whatever the
> > > > value of UserId is. However I'm getting the error that my stored
> > > > procedure expects a value for @UserId. Any insight?
>
> > > > Thanks- Hide quoted text -
>
> - Show quoted text -
