Hello everyone

im new to asp.net and im loving it .. using sqldatasource is quite easy to understand, but i think the concpt behind datasets are much better and effecient as we create another layer in between the data source and the asp.net pages .. i also use BLL to create the logic for my input and output .. im very happy so far..

but i dont understand one thing .. when i create a tableadapter in my dataset, it creates the first query or method which will also create the datatable above it with all the columns i selected in the sql query. now the problem is when i create the second method where i want to call same table but different sql colums, that doesnt work unless i add these columns to the datatable, but then when i connect a gridview to the second method, i get everything in the datatable, which i understand because the tableadapter sends the datatable to the datasource of the gridview, but i want to get the second method columns only .. how does that work?

could anyone clear up this point for me please..

thanx for your time

Btw i dont have swedish keyboard, but i do understand it if you want to answer in swedish.


Mouhannad