PLease, i need your help

[Ahmed EL Gendy]

this is a sampil code of my project how can make the data source read from variable tables ? Ex: x = TableName SelectCommand="SELECT [ReprotDate], [UserName], [ProjectName], [Report]FROM X"> how can i do this in asp.net V 2.0 ??? Best Regards Ahmed EL GEndy

[Naveed Kamboh]

x="Tablename" Using C# sqlcommand="Select field1,field2 from " + x + " order by field1"; Make sure that you put space after from and before order by clause.

Naveed Kamboh Complexity kills, Write easy code for your self. isolutionteam

[ToddHileHoffer]

I would NOT code it that way. Create a different stored procedures (or one with a tableName as a paramter). Use a switch statement to chose your stored procedure. Dynamic SQL should only be done if absolutely necessary. First of all, performance will be better if it stored procedures. Secondly, stored procedures prevent SQL Injection. Third, maintenance will be easier, especially if you change a table. Fourth, if someone else sees your code, they won't think you are a complete beginner.

GameFly free trial

[Guffa]

Why do you have separate tables with the same type of data in them in the first place? Why isn't the data in a single table?

--- single minded; short sighted; long gone;