title: Select multiple columns from multiple SQL tables in ASP.NET
body: <p>A user wants to have the option of choosing certain columns she wants to see in a grid but the columns come from several different tables. I was thinking of doing a join with all the tables and then having the user select checkboxes for the columns they want to see and then it would populate in a GridView. I am wondering if there is an easier way to accomplish this other than my method. There are about 20-30 tables and I would need to do a lot of joins to get this to work. Ideally, I would like to do it like when you use the Query Builder in SQL DataSource in ASP.NET in Visual Studio.</p>