sqldatasource – Tarik Billa

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

April 9, 2024 by Tarik

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 … Read more

asp.net dropdownlist – add blank line before db values

December 31, 2023 by Tarik

You can simply add a ListItem inside the DropDownList Markup. All the values from the DataSource will be appended after that. <asp:DropDownList ID=”drpClient” runat=”server” Width=”200px” AutoPostBack=”True” DataSourceID=”dsClients” DataTextField=”name” DataValueField=”client_id” AppendDataBoundItems=”true”> <asp:ListItem>– pick one –</asp:ListItem> </asp:DropDownList>

“Server” vs “Data Source” in connection string

November 29, 2022 by Tarik

For the full list of all of the connection string keywords, including those that are entirely synonymous, please refer to the SqlConnection.ConnectionString documentation: These are all entirely equivalent: Data Source Server Address Addr Network Address