I have a gridview in my project and i have a datasource
Let us say Gridview ID is
Gridview1
Sqldatasourse is
SqlDataSource1
I have a Table Like below
Table Name:StudentInfo
UserId UserName FirstName LastName City Designation
1 krishna krishna reddy Hyderabad Developer
2 Mohan Mohan Prasad Kumar Hyderabad Developer
3 Naresh Naresh Kumar Naresh Babu Hyderabad Designer
I have a query in
SqlDatasource1
as
SELECT *FROM StudentInfo
I have a DropdownListUserName
in DropDownList UserNames are Krishna,mohan,Naresh
when i select krishna it has to show krishna row
when i select mohan it has to show mohan row
like that
For the i used Where clause in ConfigDatasource but the problem when the page is loaded it filters the table automatically i dont
want like that when i select the username manually then only it has to work
how to do that