How to pass a variable to the SelectCommand of a SqlDataSource?

by

Try this instead, remove the SelectCommand property and SelectParameters:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:itematConnectionString %>">

Then in the code behind do this:

SqlDataSource1.SelectParameters.Add("userId", userId.ToString());

SqlDataSource1.SelectCommand = "SELECT items.name, items.id FROM items INNER JOIN users_items ON items.id = users_items.id WHERE (users_items.user_id = @userId) ORDER BY users_items.date DESC"

While this worked for me, the following code also works:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:itematConnectionString %>"
    SelectCommand = "SELECT items.name, items.id FROM items INNER JOIN users_items ON items.id = users_items.id WHERE (users_items.user_id = @userId) ORDER BY users_items.date DESC"></asp:SqlDataSource>


SqlDataSource1.SelectParameters.Add("userid", DbType.Guid, userId.ToString());

More Related Contents:

  1. Invalid postback or callback argument. Event validation is enabled using ”
  2. Object cannot be cast from DBNull to other types
  3. How can I solve a connection pool problem between ASP.NET and SQL Server?
  4. How can I get my webapp’s base URL in ASP.NET MVC?
  5. How to disable postback on an asp Button (System.Web.UI.WebControls.Button)
  6. ASP.NET MVC – Getting QueryString values
  7. System.Threading.Tasks – Limit the number of concurrent Tasks
  8. Encrypting Connection String in web.config
  9. Postback doesn’t work with aspx page as Default Document
  10. Parameterized Queries with LIKE and IN conditions
  11. Can I develop for .NET Framework 4 in Visual Studio 2008?
  12. Could not find any resources appropriate for the specified culture or the neutral culture
  13. What is the ‘page lifecycle’ of an ASP.NET WebForm? [closed]
  14. ASP.NET how to Render a control to HTML?
  15. Using scripts in a master page with ASP.NET MVC
  16. Best Practices For Mapping DTO to Domain Object?
  17. What causing this “Invalid length for a Base-64 char array”
  18. User Group and Role Management in .NET with Active Directory
  19. How to send an email with attachments using SmtpClient.SendAsync?
  20. input name and id changes when set runat=server
  21. IIS: web applications warmup
  22. How do I sync the SVN revision number with my ASP.NET web site?
  23. ASP.NET Web Forms and ASP.NET Web Pages
  24. Why are there two incompatible session state types in ASP.NET?
  25. ASP.NET strange compilation error
  26. What’s the different between ASP.NET AJAX pageLoad() and JavaScript window.onload?
  27. What does {“d”:””} means in asp.net webservice response
  28. Managing complex Web.Config files between deployment environments
  29. Integrate existing ASP.NET MVC application with Orchard CMS
  30. Why microsoft made JavaScriptSerializer obsolete prior to .net 3.5 SP1 and again active after that?

Leave a Comment