<appSettings> <add key="ConnectionString" value="Data Source=SAYAN-PC;Initial Catalog=MyPhotos;User ID=sa;Password=lock"/> <add key="MyPhotos" value="TEST_TABLE1"/> <add key="TitleField" value="1"/> <add key="RatedByField" value="2"/> <add key="ScoreField" value="3"/> </appSettings>
string p = "Select * from " + ConfigurationSettings.AppSettings["MyPhotos"] + " WHERE id = '" + Convert.ToInt32(Request.QueryString["id"]) + "'";
Quote:Error: Invalid object name TEST_TABLE1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)