static void Main(string[] args) { string pword = ConfigurationManager.AppSettings["SQL_PASSWORD"]; Console.WriteLine(pword.Length); SQLHandler data = new SQLHandler(); //ParameterSQL string conn = data.GetConnectionString("ZPC_App_Dev", "Dev"); Console.WriteLine(conn); //DataSet result = data.ExecuteQuery("CFE_Kiosk", "Dev", "StatesGET", null); DataSet result = data.ExecuteQuery("StatesGET", null); if (result.Tables.Count > 0) { foreach (DataRow row in result.Tables[0].Rows) { Debug.WriteLine(row["StateName"].ToString()); } } }