Must declare the scalar variable "@Username".
wht error it mean?
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
DeleteCommand="DELETE FROM Users WHERE [UserID] = @UserID"
SelectCommand="SELECT * FROM Users WHERE UserRoles = 'Admin'"
UpdateCommand="UPDATE Users SET [Gender] = @Gender,[Username] = @Username,[Name] = @Name,[Address]=@Address,[State]=@State,[ZipCode]=@ZipCode,[Phone]=@Phone,[EmailAdd]=@EmailAdd,[City]=@City WHERE [UserID] = @UserID"
FilterExpression="UserName LIKE '%{0}%'">
<FilterParameters>
<asp:ControlParameter Name="UserName" ControlID="txtSearch" PropertyName="Text" />
</FilterParameters>
</asp:SqlDataSource>
< ...
Go to the complete details ...