dynamically changing the datasource in codebehind file
Posted on 2014-08-01
I am using asp.net and C#. I am familiar with gridviews and datasources. However, i cannot figure out a way, using these controls, to dynamically filter results in the code behind from the sqldatasourse I have set up.
So if the query string has user="all", i want it populate the data grid with all records. If user equals a certain name, it will only show records associated wit the user.
I thought about making multiple datasources and swapping them in and out based on what comes in from the query string, but it doesn't work. The table I am getting data from is simple. It has two columns, filename and user. I want the data grid to only show the filename field, and only show what is dictated by the user found in the query string.
Also, very important. I need to wrap every result line in a hyperlink, that will use the filename data to build the final part of the url of the link