Query error?

[maniacCow]

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:foodcourtConnectionString %>" 
                                SelectCommand="SELECT [foodname], [foodimg], [price], [stallid] FROM [foodtbl] WHERE ([stallid] = @stallid)">
                                <SelectParameters>
                                    <asp:QueryStringParameter DefaultValue="<%=Session["stallid"] %>" Name="stallid" 
                                        QueryStringField="stallid" Type="Decimal" />
                                </SelectParameters>
                            </asp:SqlDataSource>

I having problem on the DefaultValue part. Kenot get the Session["stallid"]. Error there... Anyone can help..?

[benwizzle]

If your using the Session variable to get the DefaultValue, why don't you try using a session parameter? I'm not quite sure that you can use the Session variable like that as the default value(could be wrong)

[maniacCow]

Yes. I get the solution already. It is as what you mention; benwizzle

<SelectParameters><asp:SessionParameter Name="stallid" SessionField="stallid" DefaultValue="" /></SelectParameters>