I want to use one field name i take from one query as the name of the table in another one query.
How can i manage this by using asp.net 2 Sqldatasources???

To make it more clear :
I have one SqlDatasource that is : "SELECT x,y FROM XY"
The y is the name of the table i want to use.
I want to use it in another query as ...
"SELECT * FROM 'y' "
How can i take 'y' and use it ???????

Set y to a variable from your first query and do something like:

string sSql;
string sTable;

sTable = [value of first query];
sSql = "Select * from " + sTable;

//execute query

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

That is very obvious.
The problem is how to save the value from the <asp:SqlDataSource> component!
Or should i take the value from the <asp:GridView> where i am exporting these values?