How to use data binding in select parameter of sqlDataSource?

Question

I have a sqlDataSource in which I use select parameter as below :

<asp:sqlDataSource ID="EmployeeDetailsSqlDataSource" 
  SelectCommand="SELECT EmployeeID, LastName, FirstName FROM Employees WHERE EmployeeID = @EmpID"     
  ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>" RunAt="server">
  <SelectParameters>
    <asp:Parameter Name="EmpID" Type="Int32" DefaultValue="<%#userid%>" />
  </SelectParameters>    
</asp:sqlDataSource>

In my backend code, I have assigned a value to userId and also written this.DataBind();

The data-binding doesn't work. Does anyone know a solution to this ?

A good way for us to be able to help you find the problem is that if you include the C# code and the Gridview code you are using — Carsten Løvbo Andersen
– Carsten Løvbo Andersen, Commented May 26, 2015 at 12:06
Like @CarstenLøvboAndersen said, include the c# code. Probably you parameter is EmpID is not binding — Fabio
– Fabio, Commented May 26, 2015 at 12:18
Is there a reason why you need to create this and you couldn't this into a SQL stored procedure? — sleath
– sleath, Commented May 26, 2015 at 12:55

SoftwareCarpenter · Accepted Answer · 2015-05-26 14:15:51Z

One approach is to just set the value with the userid variable in the code behind Page_Load event or after you bind your variable.

 //set SqlDataSource parameters value with empID as your variable
EmployeeDetailsSqlDataSource.SelectParameters.Add("@EmpID", userID);

Asp:

 <asp:sqlDataSource ID="EmployeeDetailsSqlDataSource" 
          SelectCommand="SELECT EmployeeID, LastName, FirstName FROM Employees WHERE EmployeeID = @EmpID"
          RunAt="server"> 
<SelectParameters>
    <asp:Parameter Name="EmpID" Type="Int32" DefaultValue="0" />
      </SelectParameters>
        </asp:sqlDataSource>

Another option is to set the value from code in the selecting event which occurs before a data retrieval.

SqlDataSource.Selecting Event

Here is a link to a more complete example Full Example

<asp:sqlDataSource ID="EmployeeDetailsSqlDataSource" 
          SelectCommand="SELECT EmployeeID, LastName, FirstName FROM Employees WHERE EmployeeID = @EmpID"
          RunAt="server" OnSelecting=OnSelectingHandler">
 <SelectParameters>
<asp:Parameter Name="EmpID" Type="Int32" DefaultValue="0" />
 </SelectParameters>
 </asp:sqlDataSource>

Code behind:

Public void OnSelectingHandler(object sender, SqlDataSourceSelectingEventArgs e)
{

e.Command.Parameters[0].Value=userID;

}

Collectives™ on Stack Overflow

How to use data binding in select parameter of sqlDataSource?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related